Getting table row counts with sp_Tablecount
Sometimes you just want to get a quick row count for a specific table – other times you may want to see a list of tables order by size...
2019-11-06 (first published: 2019-10-30)
1,082 reads
Script and deploy the data for database from SSDT project
This post is a part of the series about SSDT and database project leveraging Visual Studio. We already know that SSDT can cover all objects but only on a...
2019-10-30
42 reads
Error 9002
This is very important error whenever you see this error it is clear that your database has “TLOG FILE FULL” and this could result into maintenance job failed or...
2019-10-30
33 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
8 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
27 reads
I’m Speaking at SQL Saturday Oregon
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
16 reads
SQL Server 2019 Feature Power Rankings
Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...
2019-10-29
553 reads
SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
14 reads
SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
15 reads
Last Week Reading (2019-10-27)
Hello and good morning! We have Tuesday morning, which means I experienced a delay in this post. But finally, it is out and have a look at how much...
2019-10-29
24 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers