T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-12
1,260 reads
Blog Posts
TSQL Tuesday Misconceptions in SQL Server
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,070 reads
Why do I contribute to the SQL Server Community?
As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? ...
2010-10-12
535 reads
Forgotten T-SQL Cheat Sheet
You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...
2010-10-11
1,427 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,559 reads
PASS Update #44 (Budget)
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
520 reads
Return Values from XP_CMDSHELL
Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when...
2010-10-11
17,389 reads
Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,394 reads
S–3–X Talk Week: This Totally Won’t be Awkward
We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...
2010-10-11
529 reads
SSMS Tip – Tab Groups
A few months ago as I came across tab groups in SSMS and once I found them I was very...
2010-10-11
1,097 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers