T-SQL Tuesday #86: Enhancement Requests
On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...
2017-01-10
392 reads
A Discussion of SQL Server-Related Topics
Windows Virtual Accounts and SQL Server
How SQL Server uses Windows Virtual Accounts and local groups
Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows...
2016-12-28
2,133 reads
Automating DBCC Page
Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...
2016-12-21
374 reads
T-SQL Tuesday #85: Backup and Recovery
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about...
2016-12-13
388 reads
Persisting DBCC output data
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...
2016-11-16
435 reads
The SQL Saturday Crazy Train hooks up a caboose!
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-07-20
750 reads
How do different types of functions compare performance wise?
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,026 reads
The Murder Train is pulling into Iowa City
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
565 reads
T-SQL Tuesday #61 – The Wrap-Up
Earlier this month, I hosted the 61st occurrence of the monthly TSQL-Tuesday blogging party. With a topic of “Giving Back”,...
2014-12-31
1,369 reads
TSQL Tuesday #61: How I plan on Giving Back
A little over 5 years ago, Adam Machanic (B|T) had this great idea of getting everyone in the SQL Community...
2014-12-09
701 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers