I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
GDPR is coming and many are concerned. Steve Jones has a few thoughts today.
Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension
The build v buy decision isn't the final one. We also need to decide if we'll use software as is or customize it.
As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.
Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.
Install Visual Studio 2015 in Windows Server without Internet Connection
Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.
When you need to debug or troubleshoot, Steve Jones wants you to disable, not drop, objects.
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers