Webcast Presentation Materials: Introduction to SQL Server Security
Last Thursday, I delivered a presentation for Pragmatic WorksTraining on the T’s. The session for last week was Introduction to...
2013-05-07
670 reads
Blog Posts
Webinar: Scripting and SSIS
Tomorrow at 10am (11am EDT), I’ll be joining together with my good friend and SSIS Design Patterns coauthor Andy Leonard...
2013-05-07
868 reads
XML Support and SQL Server (Part 6)
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about...
2013-05-07
561 reads
2013 Carolina Code Camp Presentations
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,016 reads
A SQL Shirt Style For Any Occasion
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
590 reads
Donating for a little kid
One of my authors sent me this note:
“
I know you only know me as a writer for SQLServerCentral, but I...
2013-05-06
700 reads
Five Ways to Improve Your Productivity with SSMS
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and...
2013-05-06 (first published: 2013-04-30)
7,717 reads
GO
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...
2013-05-06
922 reads
Last Weeks Top “Reading” Links #31
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-06
431 reads
Lost that Single-User Connection?
You have changed your database to single_user mode to do a task. As you go about your business, you lose track of which connection was the single_user connection. You...
2013-05-06
17 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers