Retrieving diagnostic data from SQL Server’s Default Trace
Have you ever tried to query the contents of the default trace and then spent more time trying to figure...
2016-07-18
468 reads
Blog Posts
Speaking at SQL Saturday #513 in Albany, NY on July 30th – PowerShell and SQL Server
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
324 reads
Speaking at SQL Saturday 513 in Albany, NY on July 30th - PowerShell and SQL Server
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
136 reads
SQL Saturday Louisville Precon – The Complete Primer to the Infrastructure Underneath SQL Server
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Louisville on...
2016-07-18
412 reads
SSC Editorial: Should I Stay or Go?
Really late linking to it, Should I Stay or Go is about being more assertive about making the decision to...
2016-07-18
350 reads
Training To-Do List for New DBA
Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the...
2016-07-18 (first published: 2016-07-12)
4,935 reads
Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported
Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you...
2016-07-17
469 reads
MeasureUp 2016
I’m heading down to Austin next weekend for MeasureUp 2016. This is a Microsoft stack conference that looks to help...
2016-07-16
551 reads
SQLSaturday Baton Rouge 2016!
Free SQL Server, SharePoint and .NET training
SQLSaturday is a global event to bring Information Technology speakers and professionals together for...
2016-07-16
449 reads
Azure SQL Database waits you should be aware of…
I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and...
2016-07-15
2,200 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
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...
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