DBCC Clonedatabase and Query Store
Cloning things is all the rage these days…..even Storm Troopers.
Anyway, by now, you probably have seen documentation on Query Store...
2018-06-04 (first published: 2018-05-25)
1,723 reads
John Morehouse | Sqlrus.com
Working with Consultants
After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several...
2018-04-27
439 reads
Database Doing DevOps
DevOps. It’s one of the latest buzz words in many technical communities. Database Doing DevOps This phrase, however, is NOT...
2018-03-30
445 reads
Community
Community.
In the SQL Server community, we are basically one big #sqlfamily. This is a story of how the family helped...
2018-03-23
376 reads
SSMS Output Window
In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time....
2018-03-16
347 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-12 (first published: 2018-03-02)
2,946 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-02
147 reads
Finding Composite Primary Key Columns
You never know when the idea for a script will make an appearance.
I had to work with composite primary keys...
2018-03-08 (first published: 2018-02-23)
3,453 reads
Backup & Restore Script with a Move
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,288 reads
4 Rules of Right When Running a Query
Last month in January, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by...
2018-02-21 (first published: 2018-02-09)
3,115 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers