A quicker way than using count(*)
A quick little tip I found a couple of years ago. Ever use the count(*) syntax and it takes forever...
2011-05-09
570 reads
SQLRally Orlando Begins This Week!
It actually starts tomorrow for me (and many of you), I’ll be at the Marriott World Center around 1 pm...
2011-05-09
828 reads
SQL Azure Migration Wizard
There’s a project over on code plex to come up with a mechanism for validating databases and generating the necessary...
2011-05-09
1,313 reads
SSC Editorial: Running as SysAdmin
My editorial about Running as Sysadmin ran in the SQLServerCentral newsletter yesterday and generated some good (and passionate!) responses. It’s...
2011-05-09
839 reads
PASSMN May Meeting
If you are going to be visiting Minnesota on May 17th or are there on more permanent basis, you can...
2011-05-09
640 reads
Minnesota SQL Server Study Group
Study Time!
A few weeks back, I sent a message on the PASSMN LinkedIn group page about expanding the MCM study...
2011-05-09
695 reads
Catalog view or compatibility view?
G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...
2011-05-08
3,017 reads
Orlando 101 For SQLRally Attendees: Weather
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...
2011-05-06
848 reads
RCSI/SI doesn't work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of
my customers. One big part of this...
2011-05-06
1,449 reads
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
401 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
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers