In this tip we look at code you can use to convert an integer date into a datetime format. This is an issue you will face when working the history data for SQL Server Agent Jobs.
2019-06-06
As database changes are added to the DevOps pipeline, unit testing of those changes becomes crucial. In this article, Adam Hafner describes unit testing and how it applies to databases.
2019-06-06
In this tip we look at a script to find SSIS packages that are stuck executing and how to end the package execution.
2019-06-05
In this tip we look at some of the advantages and disadvantages of using triggers in SQL Server.
2019-06-05
Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.
2019-06-04
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
2019-06-04
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it.
2019-06-03
SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features including SQL Server Configuration Manager and the Vulnerability Assessment tool.
2019-06-03
Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start.
2019-05-31
There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.
2019-05-31
If you want to run SSIS packages in Azure Data Factory, you need the...
Recently there was a thread on Twitter which established that a lot of IT...
When you run a query twice, and get dramatically different run times, your first...
Comments posted to this topic are about the item Statistics Profile Results
i have a sample data where i have header row / detailed / total...
Hi. I create a update trigger on a table to audit data changes... the...
Ask SSC