One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.
Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you’re probably doing upgrade projects. This is a good time to ask yourself 5 questions...
In this second part of this tip series we take a look at the dplyr package for R that can be used to query data using the R Language with SQL Server and build data visualizations.
There are a couple big changes that the cloud brings to us. Steve has a few comments today.
In this independent review of SQL Provision, the Bloor analyst finds that SQL Provision’s combination of database cloning and data masking stands out with “clear advantages over competing approaches, such as data subsetting or synthetic data generation.”
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.
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.
Not really, but sort of. The beauty of containers, at least in a dev/test...
If you are being serious in your role, then the amount of times you...
I recently did a post on the case expression short circuting and received a...
Comments posted to this topic are about the item Statistics Profile Results
There is a JAVA app that clears and reloads a staging table, but occasionally...
Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...
Ask SSC