Replicated Stored Procedure Execution
One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...
2013-09-04
2,093 reads
Will Assaf
Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
488 reads
Cannot find NT Service\MSSQL$SQL2012?
If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...
2013-08-16
1,189 reads
Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"
In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:
TITLE: Configure...
2013-08-15
11,862 reads
Baton Rouge Startup Weekend
I'm spreading the word out about an event this weekend called Startup Weekend.
It's an event for developers, designers, and entrepreneurs...
2013-08-13
621 reads
Recap from SQL Saturday Baton Rouge 2013
As the head of the planning committee for SQL Saturday Baton Rouge this year, I had the distinct pleasure of...
2013-08-04
798 reads
SQL Saturday Baton Rouge 2013
SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day...
2013-06-11
566 reads
SQL Saturday Baton Rouge Call for Speakers closes June 6!
SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).
This year's pre-conference banquet...
2013-06-04
662 reads
Hunt Down Tables Without Clustered Indexes
This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...
2013-05-09 (first published: 2013-05-03)
2,567 reads
Use the Default System Trace to Find Autogrowth Events
The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowth events...
2013-05-03
2,397 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers