You might be asking why on earth would you want to get a database into an undesirable state, more specifically into a Recovery Pending state. Well, in my case,...
2021-08-16 (first published: 2021-07-30)
1,397 reads
We are proud to feature Jessica Petrie of Yoga Next Door, HBCU Gameday, and other inspiring customers at the second Official WordPress.com Growth Summit, on Tuesday, August 17.
2021-08-16
25 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-13
10 reads
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-13 (first published: 2021-08-01)
437 reads
Here is a simple T-SQL script that may come handy if you need the month end dates of last N months. N is the number of months. The output...
2021-08-13
1,011 reads
In a previous post I told you about how I got a Synology DS920+ on loan to play around with. The device comes with 4 drive bays so there...
2021-08-13
2 reads
New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.
In this blog post, I covered how to simplify large SQL Server database migrations...
2021-08-13 (first published: 2021-08-03)
142 reads
After many years working with different “flavours” of SQL server in Azure from its true PaaS form to SQL server in AKS (Azure Kubernetes Service) it’s time to look...
2021-08-12
182 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-12
24 reads
Just some handy commands to use via kubectl. I found these useful for various reasons so hopefully you will too. Overview of our nodes. Pod information, remember from my...
2021-08-11
37 reads
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Comments posted to this topic are about the item How Do You Patch 100...
Comments posted to this topic are about the item Microsoft SQL announcements at PASS...
Comments posted to this topic are about the item How to Develop Custom T-SQL...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers