The Primary Filegroup Cannot be Backed Up as a File Backup
File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come...
2014-03-31
2,751 reads
Send SMS from SQL Server
We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...
2014-03-31
1,969 reads
Last Weeks Top “Reading” Links #77
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-31
1,954 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,205 reads
SQL Server Quickie #12 – Nested Loop Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31
1,418 reads
We Are Hiring!
My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's. As you have probably seen...
2014-03-31
1,250 reads
GetLogSpace – table and stored procedure
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote...
2014-03-31
1,263 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,046 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,210 reads
SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
971 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers