SQL University: Introduction to Indexes
For some crazy reason (probably everyone is on vacation), Jorge Segarra (blog|twitter) who runs SQL University has asked me to...
2010-07-16
555 reads
Article Featured on SQLServerCentral
My article, ANSI Padding, Trailing Whitespace, and Variable Length Character Columns, is featured in today’s SQLServerCentral newsletter. Check it out!...
2010-07-16
366 reads
Advanced Troubleshooting Week at SQL University, Lesson 2
Advanced Troubleshooting Week at SQL University, Lesson 2
Welcome back to Advanced Troubleshooting Week at SQL University. I’m your guest professor...
2010-07-16
2,019 reads
The Wiffle-Waffle, or Why I’m Running for the PASS Board of Directors
I’ll announce it here first, along with some reasons why I’m waffling from an earlier post:
I’m going to run...
2010-07-16
2,200 reads
The week that was: Friday 15th July 2010
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
648 reads
Book Review: Rework
I recently read Rework by Jason Fried of 37 Signals ($13 @ Amazon) and it talks about a lot of philosophy...
2010-07-16
547 reads
SubQuery Performance
Why would you do this?
select distinct(hostname),
(select count(*) as criticalCnt
from @temp where severity_guid='0168A833-1732-411E-8205-C2F6CD91737D'
and hostname=t.hostname
group by hostname),
(select count(*) as criticalCnt...
2010-07-16
1,927 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
15 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
63 reads
How Can I Quickly Script Out Replication?
I recently finished taking down a bunch of servers that I was using to scale out my environment by forcing...
2010-07-16
526 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
10 Reasons the 2CT Engagement Ring Is the Most Popular Proposal Choice Right Now
Walk into any jewelry consultation these days and you’ll hear a familiar request: “Something...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers