A Script A Day - Day 16 - Database Restore
Today’s script is one I have used more times that I care to remember. As a DBA database backups and...
2012-02-22
678 reads
SQL Server 365
A Script A Day - Day 15 - Untrusted Check Constraints
Today’s script comes about because of a recent discussion about check constraints. The discussion was about the use of WITH...
2012-02-22
1,025 reads
A Script A Day - Day 14 - Upgrading to SQL 2012
Today’s script is one I have used to test one possible upgrade method from SQL Server 2008 to SQL Server...
2012-02-21
972 reads
A Script A Day - Day 13 - Chris' Top Tip - Batches
Today’s post is pretty cool. So you have been reading up about something on the World Wide Web or you...
2012-02-21
464 reads
A Script A Day - Day 12 - Granting Role Membership to All Principals
Today's script will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...
2012-02-20
899 reads
A Script A Day - Day 11 - User Permissions By Database
Today's script will return you permissions granted to a user for every online database. The script uses EXECUTE AS so...
2012-02-20
1,096 reads
Sorry...
I've been offline for a week to take some annual leave and recharge my batteries. To make up for the...
2012-02-20
464 reads
A Script A Day - Day 10 - Hosts on vCentre
If you use VMWare for your virtualisation environment all virtual machines are managed by one or more vCentre management servers. ...
2012-02-10
706 reads
A Script A Day - Day 9 - Index Compression Estimations
Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...
2012-02-09
1,312 reads
A Script A Day - Day 8 - Non Clustered Index Information
Today's script comes to you from London where I am at my head office for my appraisal! Lets hope it...
2012-02-08
448 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers