On the Advantages of DateTime2(n) over DateTime
Starting with SQL 2008, we database developers started becoming more familiar with datetime2. Sometimes folks need convincing though, so here...
2012-12-04
12,264 reads
Will Assaf
PowerPivot for Excel "Not loaded. The Managed Add-in Loader failed to initialize."
Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:
"Not loaded. The Managed Add-in Loader failed...
2012-11-30
6,431 reads
Database Design Contest at the 2012 AITP Region 3 Student Conference
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 reads
Performance Tuning Presentation from October 2012 BRSSUG Meeting
Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone...
2012-10-11
756 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,752 reads
SQL Server Best Practices for DMV's - Houston Tech Fest 2012
It is a pleasure meeting everyone today at Houston Tech Fest! The new facility is miles away - literally and figuratively...
2012-09-08
942 reads
SQL Agent Alerts - Severity Condition is NOT "greater than or equal to"
I ran into some bad training that had convinced a client sys admin that the SQL Agent Alerts had the...
2012-08-20
2,267 reads
Actual Emails: The Customer Doesn't Want Full Recovery Mode
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
685 reads
SQL Saturday #150 Baton Rouge 2012
Baton Rouge SQL Saturday is Saturday, August 4!
We expect ~400 attendees at the brand new LSU Business Education Centre of...
2012-07-27
774 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,068 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
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...
Storytelling with Data: Let's Practice!
Comments posted to this topic are about the item Storytelling with Data: Let's Practice!
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