Thoughts About The Nail
The other day Grant Fritchey (Blog | @GFritchey) linked out the video below. It’s a quick little video, that isn’t about the...
2013-05-31
1,326 reads
Reblog: May 24 to May 30
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-31
1,172 reads
TSQL Snippet for viewing basic info on database principals and their permissions
Quick snippet I put together for reviewing basic info on database users/principals, permissions, and members if the principal is a...
2013-05-31
1,537 reads
SQL and Relational Theory
Do you know the foundation of SQL? According to the book Querying Microsoft SQL Server 2012 Training Kit on the...
2013-05-31
1,008 reads
Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM
In this blog post I’ll explain how I build the VM and VHD for my virtual demo environment. I use...
2013-05-31
1,720 reads
Exploring a Database in Azure
After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied...
2013-05-30
1,656 reads
SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances
One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying...
2013-05-30
1,544 reads
Security Questions: TRUNCATE TABLE Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-30
1,711 reads
Ralph Kimball Books
If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:
The Data Warehouse Lifecycle Toolkit: Practical...
2013-05-30
2,553 reads
A moment of void in the cranium reveals a recursive computed column with an esoteric message
Msg 402, Level 16, State 1, Line 67
The data types varchar and void type are incompatible in the add...
2013-05-30
1,385 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers