PowerShell Split-Path Bug And A Workaround
Split-Path is a cmdlet built into Windows PowerShell that returns a specific part of a path, e.g. a parent directory...
2012-09-05
2,622 reads
Blog Posts
Cisco VPN Client 5 on Windows 8
NOTE: Always create a backup before doing any type of Windows registry modifications!!!!
With the full public release of Windows 8...
2012-09-04
1,466 reads
2012-09-04
663 reads
Error: No mapping between account names and security IDs was done
I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a...
2012-09-04
11,086 reads
Normalization & Denormalization
Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should...
2012-09-04
1,344 reads
Our weekly webshow starts Friday! #DBAsAtMidnight
Let’s pretend we’ve never met. Depending on who you are, maybe we haven’t. It’s beside the point, really.
So hi, I’m...
2012-09-04
922 reads
PASS SQL Saturday - September 2012
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2012-09-04
636 reads
PASS Virtual Chapter Events - September 2012
PASS DBA Fundamentals Virtual Chapter
fundamentals.sqlpass.org / Twitter: @DBAFundVC
September 4, 2012 - 11:00 a.m. CST
Introduction to SQL Server Service Broker
Speaker: Adam Belebczuk
In this...
2012-09-04
1,066 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session and the SQL Community is still busy. With that,...
2012-09-04
4 reads
September Events
Wow, I can’t believe it is already September of 2012. Labor day has come and gone, school is in session...
2012-09-04
885 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