Symmetric Keys
One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...
2013-12-23 (first published: 2013-12-16)
2,943 reads
Blog Posts
The Night Before Upgrade
I originally wrote this in December 2011. It’s been one of my most popular posts, so reposting it has become...
2013-12-23
456 reads
Tribal Awards: Vote Now!
The #tribalawards voting is now online. Get over there and get it done.
I honestly don’t care who you vote for...
2013-12-23 (first published: 2013-12-20)
923 reads
Android is better than iOS
Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are...
2013-12-20
1,132 reads
Assign SQL Service Account with Group Policy
How do I assign and enforce a service account for the SQL Server Services with Active Directory Group Policy?
The answer...
2013-12-20
6,841 reads
Case-Sensitive Updates in a Case-Insensitive World
Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:
UPDATE tablefoo
set foo = 'Z'
where foo = 'z'
will just...
2013-12-20 (first published: 2013-12-16)
1,814 reads
Friday Followup For December 20, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-20
555 reads
Reblog: December 13 to December 19
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-20
868 reads
Setting up Security on sub sites in SharePoint 2010
A lot of companies have several departments and want to limit the sub sites users can view. For example, the...
2013-12-20 (first published: 2013-12-16)
1,545 reads
How to Set Up Managed Backups in SQL Server 2014
Earlier this week I introduced the concept of Managed Backups (and caused less of a turmoil than I thought I...
2013-12-19
2,858 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers