SQLMentor: Do you have a mentor?
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos...
2013-04-13
735 reads
Parsing Glenn Berry’s Diagnostic Information Queries With PowerShell
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,269 reads
Introduction to SQL Server 2012 – Webcast Resources
First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to...
2013-04-12
1,040 reads
Data Warehousing Tip: Surrogate Key Generation
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to do a table based surrogate key assignment or use...
2013-04-12
30 reads
Data Warehousing Tip: Surrogate Key Generation
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...
2013-04-12
944 reads
Reblog: April 5 to April 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-12
405 reads
SQL Saturday#197–Omaha Recap
This was the second SQL Saturday hosted in Omaha. I loved to see how the event grew from the first...
2013-04-12
480 reads
DBA Question of The Day: What is SAVE TRANSACTION?
Hello Dear Reader! I was teaching a class in Chicago last week and I got a lot of really great...
2013-04-12
1,138 reads
SQL Server – Add Date/Time to output file of BCP / SQLCMD (2)
Last time I posted about How you can add date/time to output file name, in which I used xp_cmdshell to...
2013-04-12
2,369 reads
PASS Business Analytics Conference Live Blog
Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...
2013-04-12
741 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers