The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
650 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
409 reads
Not More Than 16 Characters?!?
Microsoft, you’re killing me. This is the warning I received when typing in a password for Office 365:
I blinked when...
2016-06-16 (first published: 2016-06-10)
4,095 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book! Another free indexing books, more awesome! In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server;...
2016-06-10
12 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book!
Another free indexing books, more awesome!
In last week’s post, I talked about how I’ve got a number of copies...
2016-06-10
944 reads
Database Scoped Configurations
In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations.
This...
2016-06-10
2,097 reads
SQL Server 2016 NYC Launch Event - Slide Decks Posted!
Quick post-event follow-up of our very successful SQL Server 2016 NYC Launch Event! We would like to thank ALL our...
2016-06-10
1,429 reads
MS Exams Increasing In Price
Just glanced through the MCP newsletter and see that the price of the exams (or at least the one I...
2016-06-14 (first published: 2016-06-09)
2,659 reads
PowerShell – Disk Space Monitoring and Early Warning Reports
Disk space is one of those things that frequently runs out of space no matter how much you bump it...
2016-06-09
1,345 reads
Protecting Against Delete without Where
If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...
2016-06-13 (first published: 2016-06-09)
3,645 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
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
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...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers