My articles published on SearchSQLServer.com from January 2014 to September 2014
The following is the list of my articles published on SearchSQLServer.com from January 2014 to September 2014. To read these...
2014-09-09
900 reads
Blog Posts
PowerShell Snippets A Great Learning Tool
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...
2014-09-09
731 reads
T-SQL Tuesday #58 - Passwords
This month’s T-SQL Tuesday topic is passwords. I’m neither a DBA nor server/system admin, so the only passwords I get to manage are my own. But there’s still lots to...
2014-09-09
4 reads
T-SQL Tuesday #58 – Security Phrases
Today is once again TSQL Tuesday. This month the event and topic are being hosted by Sebastian Meine (blog | twitter). You can read all about the topic this...
2014-09-09
4 reads
Untested
The 2014 Apple keynote was today, with the announcement of the iPhone 6 and iWatch taking center stage. I was...
2014-09-09
780 reads
Better Presentations–Fonts
This is part of a series of tips for speakers to make your presentations better.
Please, please, please, learn how to set...
2014-09-08
825 reads
How to Start SQL Server in Single User Mode ?
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master...
2014-09-08 (first published: 2014-09-04)
43,849 reads
I'm Speaking at SQL Saturday 300 - Kansas City and a Few Questions About SQL Saturdays!
This is just a short update. I will be speaking at SQL Saturday Kansas City! I really hope to see...
2014-09-08
586 reads
Left or Right?
No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a...
2014-09-08 (first published: 2014-09-03)
6,767 reads
SQLSaturday Orlando Marketing Plan-Part 41
Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is...
2014-09-08
516 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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