PowerShell Script for Creating Indexes
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,800 reads
The Scary DBA
What three events brought you here?
Another one of the DBA bloggers games of tag is occurring. I’ve been asked by Tom LaRock to answer Paul...
2010-01-18
744 reads
Database Design Process
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked...
2010-01-18
1,900 reads
SQL Server Standard Volume 7 Issue 1
Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more...
2010-01-13
833 reads
Excel Within Management Studio
Aaron Bertrand has put in a Connect request for a feature whereby data returned as a grid from a query...
2010-01-13
747 reads
Connections Sessions Evals
I’ve kind of been embarassed to post these despite the fact that I received them a couple of weeks ago....
2010-01-13
563 reads
TSQL Tuesday #2
I’ve wracked my brain for some bit of puzzle that I could present as part of TSQL Tuesday #2 and I...
2010-01-12
1,112 reads
Horror… sort of
You must read this post from Tim Ford to understand why I might do this on my technical blog. But...
2010-01-11
878 reads
New England Data Camp v2/SQL Saturdy #34 Update
The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set...
2010-01-11
546 reads
PASS Summit Evaluations
The big day has arrived and all the speakers are poring over their PASS Summit 2009 evaluations, me included. These...
2010-01-06
691 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
Sql query to check the status change for an item
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
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...
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