SQLBits Friday and Saturday
By David Postlethwaite
The last two days of SQL Bits provide opportunities to hear short 50 minutes presentations from experts
on a...
2011-10-06
717 reads
Gethyn Ellis
SQL Bits Training Day
By David Postlethwaite
Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing...
2011-09-29
1,590 reads
David’s SQLBITS Day 1–The Travel Day
Just had a pleasurable 5 hours watching the Autumn countryside go by on a glorious sunny day (in fact its...
2011-09-28
724 reads
Sharon Dooley’s Lightening Talk and the WIT Luncheon
At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her...
2011-08-31
2,521 reads
Using PowerShell to Monitor SQL Server
By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example,...
2011-08-30
7,307 reads
VMFS LUN resizing options in vSphere
Introduction
First off, many thanks to Gethyn for the opportunity to post on his excellent blog.
I’m Christian Dadswell and I...
2011-08-24
1,843 reads
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...
2011-08-22
936 reads
Another New Contributor–Christian Dadswell
This is just a short post to introduce you all to my good friend Christian Dadswell who has kindly agreed...
2011-08-17
863 reads
Auditing SQL Logins Addendum
One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....
2011-08-16
765 reads
Auditing SQL Logins Part II
Written by David Postlethwaite
In a previous blog I talked about how to audit successful logins. So what about failed logins?
As...
2011-08-15
1,475 reads
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