PASS Nomination Committee
For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...
2012-06-13
802 reads
The Scary DBA
Guest Blog
I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...
2012-06-05
938 reads
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,305 reads
Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,359 reads
Rolling out Windows 8 Client: First Impressions
A virus found it’s way on to my system through a trojan horse, past all the security & anti-virus software. I...
2012-05-28
1,026 reads
Is Dynamic T-SQL a Good Design Pattern?
In a recent discussion it was suggested to me that not only is dynamic T-SQL useful for things like catch-all...
2012-05-21
1,274 reads
Don’t You Know Who I Am?
I’m happy to say that for most of you out there, the answer to this question is “no.” That’s as...
2012-05-16
818 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,397 reads
Changing DB_CHAIN Can Clear the Plan Cache
If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft...
2012-04-30
1,753 reads
AlwaysOn Failover Bug
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...
2012-04-26
1,243 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers