The Service Pack Fiasco
The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.
2015-05-11
206 reads
Editorial
Not Only a Meeting of Minds, but of Open Minds.
In which Phil Factor claims that professional application development requires a broad knowledge base.
2015-05-11
99 reads
How Virtualized?
This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.
2019-03-20 (first published: 2015-05-08)
187 reads
vNext 2016
Steve Jones looks at the next version of SQL Server, SQL Server 2016. Until this week, it was known as vNext.
2015-05-07
270 reads
Idempotent
There are all sorts of coding practices that produce better code. Steve Jones talks about one today.
2024-11-04 (first published: 2015-05-06)
552 reads
Can Auditing Fail?
It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.
2018-10-26 (first published: 2015-05-05)
140 reads
2015-05-04
57 reads
Complete Definitions
When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.
2015-05-04
123 reads
Finding Problem Code
This week Steve Jones has a poll on performance tuning code. Since many people aren't experts, the answers this week might help them learn where to focus their efforts.
2015-05-01
219 reads
Is It Time to Upgrade?
Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.
2015-04-30
192 reads
Blogs
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers