Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the largest Microsoft Data Platform conference in the world, PASS Summit 2019,… Read More »Speaking at PASS Summit 2019
Home » Maintenance »
Maintenance
Proposed SQL Server defaults: optimize for ad hoc workloads
(This post was updated on 5 February 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: optimize for ad hoc workloads
SQL Server on Linux – feature change in Pacemaker 1.1.18
Heads up for SQL Server on Linux folks using availability groups and Pacemaker. Pacemaker 1.1.18 has been out for a while now, but it’s worth… Read More »SQL Server on Linux – feature change in Pacemaker 1.1.18
Proposed SQL Server defaults: disable priority boost
(This post was updated on 5 February 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: disable priority boost
Proposed SQL Server defaults: disable lightweight pooling
(This post was updated on 5 February 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: disable lightweight pooling
Database modelling in a post-SSMS world: dbForge Studio
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams feature from v18.0 onward. [Edit:… Read More »Database modelling in a post-SSMS world: dbForge Studio
Infrastructure matters, even in the Cloud
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK and POKE, all bring a… Read More »Infrastructure matters, even in the Cloud
Some databases may show a NULL collation in the sys.databases DMV
While working on my Swart’s Ten Percent Rule post last week, I needed to test the Windows version of the script on my SQL Server… Read More »Some databases may show a NULL collation in the sys.databases DMV
Fix SQL Server with one click
(This post was updated on 5 February 2022.) Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL… Read More »Fix SQL Server with one click
Changes to the SQL Server servicing model (Cumulative Updates)
On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017. From today onward, we can… Read More »Changes to the SQL Server servicing model (Cumulative Updates)
Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I… Read More »Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Update your production servers and stop making excuses about it
Folks, we all like to make sure we’re doing our level best to make things work smoothly. So why am I staring at someone’s server… Read More »Update your production servers and stop making excuses about it
T-SQL aside: replace PRINT with RAISERROR
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in the proverbial forehead. I even… Read More »T-SQL aside: replace PRINT with RAISERROR
Virtual Log Files: 200 or 1000?
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During the follow-up meeting, the senior… Read More »Virtual Log Files: 200 or 1000?
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM)… Read More »Secure or fast? Secure, obviously …
- « Previous
- 1
- 2
- 3
- 4
- Next »