Eliminating Duplicate Rows using The PARTITION BY clause
The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.
High Availability Upgrades
Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgrade for your company?
Stairway to SQL Server Replication - Level 8: Merge Replication – How it works
How merge replication works, including the impact on the published database. The merge agent, different conflict situations and their resolutions are introduced.
Exploring SSIS Architecture and Execution History Through Scripting
When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the execution history of scheduled SSIS jobs. You can do this type of work effectively in T-SQL as Feodor Georgiev explains.
Change the port number for connections to SQL Server
How to change the port number for connections to SQL Server.
Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
Use the 4th Dimension
Today Steve Jones talks about the conflicting demands of home and work and how you can reconcile the requirements of both.
Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
Insert, Update, and Delete Indexes: Stairway to SQL Server Indexes Level 13
What happens to your indexes during normal database activity?
The Cloud is good for your career
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
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