Always Check on the Basics
The basics are important, especially with regards to backup and restore in SQL Server.
2019-08-31
221 reads
Database Weekly
Best Practices and Band Plans
Grant Fritchey explains how database best practices should be followed more like those in Ham radio.
2019-08-03
357 reads
SQL Server 2019 CTP 3.2 Available
Microsoft announced CTP 3.2 for SQL Server 2019 just a few days ago, but many people working with SQL Server don’t care about this. I run into people at user group meetings and SQL Saturdays who are stuck supporting versions as old as SQL Server 2000, and SQL Server 2008 R2 is still prevalent. I’m […]
2019-07-27
501 reads
Do You Have the Gifts to Be a DBA?
I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. A familiar tale he tells is about when he wrote the song Yesterday. He woke up with the tune […]
2019-07-13
298 reads
More Linux than Windows
Microsoft announced that Linux runs on more machines in Azure than Windows. Steve isn't surprised and thinks that Linux use will continue to grow.
2019-07-06
159 reads
Microsoft, Think DevOps First
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
277 reads
Microsoft and Oracle Cloud Partnership
Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]
2019-06-15
199 reads
Building or Buying Analytics
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. […]
2019-06-08
183 reads
Why Tools Can Help You Do Your Job
Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was a problem with one instance that wasn’t currently being monitored, I would have to stop monitoring another instance […]
2019-05-18
200 reads
2019-05-11
104 reads
Blogs
ASF 032: Jennifer Stirrup interview
By Kamil
Introduction Jennifer Stirrup is a data strategist and technologist, Microsoft Data Platform Most Valuable...
SQL Server Express Size Limit
By Kevin3NF
My Pluralsight course for new SQL Server DBAs (Needs to upgrade to a...
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Adding NOT NULL to column with existing rows causes page bloat
Hi, I'd like to know why the page count is almost exactly doubled for...
Stretch database
Is there anything similar to a stretch database in mysql where an on-premise mysql...
Partitioning Heaps
Comments posted to this topic are about the item Partitioning Heaps
Ask SSC