For this month's #tsql2sday post, I'm sharing a script I use to capture all a databases indexes. You know... in case you ever need to nuke them all from orbit (it's really the only way to be sure). read more
Sometimes the most useful scripts are the most straightforward: here's how you can return all your space used by your table objects on an entire SQL Server instance. read more
It's 10 PM: do you know how many of your database objects contain linked server references? read more
What started out as way to explore a command line tool for SQL Server wound up taking me down memory lane. read more
Since we did it on Ubuntu, let's keep the Linux party going: Here's how you can set up SQL Server Active Directory authentication with CentOS. read more
SQL Server on Linux is here, and if you want to use Active Directory authentication, there's a lot of steps involved to get it working. Let's walk through the configuration on Unbuntu! read more
If you work with SQL Server transactional replication, here are my top three replication-specific stored procedures that I think you should know about. read more
It turns out that when you actually stop to write it all down, your community contributions can add up quick. read more
Replication latency is usually the result of large transactions and the number of rows they insert into the distribution database. There's a way around that, though. A very dangerous way, it turns out. read more
You think your SQL Server data is encrypted? If you use replication, you might be in for a nasty surprise. read more
- 1
- 2