Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes
Find out how to speed up your queries by indexing and partitioning data, U-SQL style.
Stretch Database in SQL Server 2016 RTM
Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.
Data Overload
When do you have too much data? What do you do if you aren't actually using all of it?
Reclaiming Space After Column Data Type Change
A brief overview of how to reclaim storage space after altering the data type of a column.
Steps to change the server name for a SQL Server machine
In this tip Jugal Shah looks at the steps within SQL Server you need to follow if you change the physical server name for a standalone SQL Server.
Backup Strategy in Azure SQL?
Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.
Making Complex Table Changes
The complexity of tables makes modifying them over time a challenge, especially as data sizes grow.
Security Shaming
This week Steve Jones looks at a new idea, rating the security of products publicly to try and shame vendors into more secure coding.
Failover
Too many failovers can cause problems, as can those that happen to often. Steve Jones says you need to consider whether you always need to failover in a sitaution.
SELECT INTO vs INSERT INTO on Columnstore
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers