How to open Task Scheduler by cmd

Question: I'm on a Windows 2016 trying to open Windows Task Scheduler by cmdline - but it's not opening?Could you lete me know the cmd line reference for opening Windows Task Scheduler? Answer: To start Windows Task Scheduler on Windows 2016 use this cmd from the cmdline function: control schedtasks This will open a GUI similar to this one: Read More on Windows Administrative tasks Windows Server 2012 empty recycle bin (SQL Server DBA) Find Windows pagefile location through command line and How to write to a sql error to windows server event viewer (SQL ... Read more →

Should I use SQL Change Data Capture for data audit ?

Question: There is lots of information around the SQL Server Change Data Capture (CDC) feature, and I’m trying to decide if CDC is suitable for the purposes of a project which requires data auditing. We currently have a sql server triggers based solution in place for capturing data changes on certain tables. Could you outline some the issues to consider when deciding if CDC is an appropriate tool. Answer: Deciding on when to adopt CDC is dependant on the specific requirements. The first step is to understand in detail the project requirements. As you mentioned in your question, there are... Read more →

How to mount an ISO - Disk Image File

Question: I’ve received some ISO files with the contents of SQL Server Enterprise and need to open them and retrieve the contents. I don’t have a specific disk image tool. I’m on a Windows 2012 server . Are you able to offer any advice or assistance? Answer: Windows Server 2012 supports the facility to Mount an ISO file without installing any extra software. Previously you needed a disk image tool installed. Back in the good old days of SQL Server 2005 - the process required extraction first - read more on SQL server 2005 install with ISO images Now all... Read more →

What is acceptable database server performance testing

A new storage vendor with a new faster way of storing and retrieving data pitches their product. Your company is interested in testing out the new platform. The new platform promises consolidation, more flexible provisioning of disk and disk tiers. They come to you as the DBA looking for a comprehensive test from the SQL Server perspective. From a workload perspective database servers tend to be high on the list of heavyweight IO consumers. It’s important at this point to understand the scope of the testing. 1) What exactly are you testing? Is the storage tier the intended purchase -... Read more →

How to use GO command for multiple execution of sql statements

A useful feature of the GO command is the possibility of using the count Argument. For example, if I issue this sql staement through SSMS , it will run the once: select @@servername GO but if you execute the following sql statement , it will run three times select @@servername GO 3 This is a fairly simple example. It is possible to extend this idea into a very simplistic performance testing or functionality testing method. I stress the word simple. In a more comprehensive test, you might use a product such as JMeter where you can simulate some workload. The... Read more →