Baselines
It can be hard to analyze performance without a baseline. This week, Steve Jones asks how you might use your baseline to better determine what problems you are having with your SQL Server.
Join Operations – Nested Loops
This is part I of III in a series on the physical join operators in SQL Server.
Silent Truncation of SQL Server Data Inserts
There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.
A New Type of Colocation Facility
Microsoft is working on their generation 4 data centers, which might be a great idea for companies if they can implement a private cloud.
Custom Metric - Indexes with Excessive Writes
A new custom metric is available at SQL Monitor Metrics. This tracks indexes that have more writes than reads. Use this code if you want to find out if you might be over indexing your tables.
SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell
Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.
Stairway to XML: Level 9 - Creating XML-Based Functions
In this Level, we’ll look at how to use XML methods within user-defined functions to return XML fragments and values from your target XML instance.
The Knowledge Graph
Google has a new project to use a "database of everything" to help you learn more.
SQL Server Performance Tuning – Index Tuning
In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning
Acing an Audit
Audits for technology groups can be time consuming and stress employees out. An article Steve Jones finds says an insurance company only needed 30 minutes to ace their audit.
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