SQL Server Configuration Manager (sqlserverManager11.msc) Hidden after Windows 8.1 Upgrade
You may have noticed, like I did, that after upgrading-in-place from Windows 8 Enterprise to Windows 8.1 Enterprise, my local...
2013-10-22
7,256 reads
Blog Posts
Why I’m Excited About Hekaton
I recently readMicrosoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014. When I first heard...
2013-10-22
2,339 reads
Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,198 reads
Last Weeks Top “Reading” Links #54
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-21
864 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
971 reads
No, Simple Mode Doesn’t Disable The Transaction Log
If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant...
2013-10-21
6,260 reads
PASS Summit 2013 and SQL Saturday Charlotte in Review
I love reading the many blogs posts that pour in following a PASS Summit. I think it is fun to...
2013-10-21
766 reads
PASS Summit 2013-Almost Final Thoughts
I’m home in Orlando, reveling in not being jet lagged for once. A great traveler I am not. I was...
2013-10-21
651 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013. The abstract is below. It...
2013-10-21
766 reads
Presentation Slides for Transitioning to a BI role
Thanks to everyone who attended my session “Transitioning to a BI role” at the PASS SQL Saturday Charlotte. The abstract is below. Another...
2013-10-21
695 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