Should I Run for the PASS Board of Directors?
I saw the recent Call for Nominations for the election this year, so the title of this post is only...
2008-10-13
521 reads
Blog Posts
SQL Server MVP
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
873 reads
SQL Saturday in Olympia , WA Pulls in Crowd of over 130 DBAs and Developers
A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server...
2008-10-11
561 reads
Database Health - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-10
616 reads
One File Per Core?
For a long time in my career I heard various advice on how many files you should create for a...
2008-10-10
955 reads
Do You Understand Microsoft Licenses?
I had an email from a friend recently asking about a licensing question pertaining to Microsoft. It reminded me of...
2008-10-09
540 reads
Meeting My Goal
Last year I was talking about goals and changes for the site as I was negotiating my continued employment with...
2008-10-09
838 reads
Project Management Management - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-09
931 reads
Tulsa TechFest Draws a Crowd of Over 500
The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday....
2008-10-09
440 reads
Validating text data. A few techniques.
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,093 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers