A Server Bench
This past weekend I was doing some early Spring cleaning and decided it was time to throw out two old...
2014-01-15
631 reads
SQLAndy
Should You Run For the PASS Board? How Do You Decide?
Here are some of the questions I ask when someone is thinking about running for the Board:
Are you eligible? Read...
2014-01-15
544 reads
Google Buys Nest
I was a bit sad to see that Google bought Nest. I like upstarts that see a problem and solve...
2014-01-14
629 reads
Time to Plan For Running For The PASS Board
I know it’s only January, but if you’re at all considering being a candidate you need to get going now....
2014-01-14
434 reads
Security, Compliance, and SQL Server Webinar on January 29, 2014
My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL...
2014-01-27 (first published: 2014-01-13)
979 reads
Bradley Ball at MagicPASS on January 15, 2014
First meeting of the year with Bradley Ball presenting Locking, Blocking, Latches, Deadlocks, and Spinlocks. Let them know you’ll be...
2014-01-13
663 reads
The SQLSaturday Wiki–Revisited
I saw a discussion on Twitter yesterday where Kendal Van Dyke referenced the SQLSaturday wiki as a resource, I thought...
2014-01-10
385 reads
Schedule Time To Review Your Passwords & Using a Password Manager
I use a password manager and it currently has more than 150 accounts in it, ranging from my checking account...
2014-01-17 (first published: 2014-01-10)
1,805 reads
How To Campaign For the PASS Board
Let’s say you’ve decided to run, good! What do you do next? I’m not going to give you a blueprint...
2014-01-10
391 reads
Two-Factor Authentication
Something you have and something you know – that’s the heart of two-factor, sometimes called multi-factor, authentication. RSA was for years...
2014-01-15 (first published: 2014-01-09)
6,350 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