When were statistics updated?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-16
659 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,528 reads
Help! My backup file has doubled in size.
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
616 reads
A Better (Free) Search in SSMS
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,078 reads
I am speaking at SQL Saturday Louisville 2016!
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at the upcoming Louisville #531, Saturday, Aug. 6th, 2016. My...
2016-06-14
21 reads
I am speaking at SQL Saturday Louisville 2016!
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at...
2016-06-14
144 reads
What’s New in Reporting Services 2016
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long...
2016-06-21 (first published: 2016-06-14)
5,423 reads
Power BI Custom Visuals Class (Module 03 – Hexbin Scatterplot)
In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual. The Hexbin Scatterplot is...
2016-06-23 (first published: 2016-06-14)
2,910 reads
Because
Because there’s nothing else I can do at the moment.
The post Because appeared first on Home Of The Scary DBA.
2016-06-14
536 reads
OmniCompare: A free tool to compare SQL Instances
comparing instances
When working with a variety of instances, you can often deal with variances in configuration that might impact the...
2016-06-22 (first published: 2016-06-14)
2,876 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers