Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
713 reads
Kenneth Fisher
What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
619 reads
Where you should start when managing an enterprise
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us...
2015-09-11 (first published: 2015-09-08)
1,857 reads
The default instance has a name
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,278 reads
Learning Regular Expressions
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term...
2015-09-02
954 reads
SSMS’s Clipboard Manager
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask...
2015-08-28 (first published: 2015-08-19)
2,821 reads
The 30 minute rule
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule....
2015-08-26
660 reads
Pulling data from the error log
The other day I was asked to pull a list of errors from the SQL Server log into a table...
2015-08-25 (first published: 2015-08-17)
3,282 reads
The tail of the log
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...
2015-08-24
647 reads
Getting and storing a high precision datetime
Earlier today I was working on a project where I was recording some time stamps. In order to get as...
2015-08-13
581 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Cs Lion Air Tower Tlp/ Chat 087757643837
Layanan bantuan Refund dana reschedule booking tiket Cs Lion Air WhatsApp 087757643837 <!--more-->
BCA KCP Arundina Cibubur Telpon/WA:08213111185
BCA KCP Arundina Cibubur Telpon/WA:08213111185 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26...
BCA KCU BINTARO Telpon/WA:08213111185
BCA KCU BINTARO Telpon/WA:08213111185 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers