SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...
2012-02-26
917 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
[Shameless Plug] Can We Have Your Vote?
[Shameless Plug] Can We Have Your Vote?
SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...
2012-02-08
1,059 reads
Breaking Down TempDB Contention (part 2)
Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...
2012-01-30
2,990 reads
The Kind of DBA I Want to Be
The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)
I was a big fan of the original Iron...
2012-01-27 (first published: 2012-01-22)
2,791 reads
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Data
One of the ways that I learn new things...
2012-01-14
1,712 reads
Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production
Production Line
Webcast:Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00...
2011-12-26
1,240 reads
Using Dynamic Values in XMLA
Using Dynamic Values in XMLA
XMLA
A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...
2011-12-18
1,928 reads
Undocumented Gotchas of Transactional Replication
Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...
2011-12-17
1,390 reads
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
Subject:Row Versioned Data WarehousesStart Time:Thursday, December 15, 2011 6:00 PM US Pacific...
2011-12-14
804 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,059 reads
Blogs
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers