Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
672 reads
Blog Posts
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is...
2017-01-31
538 reads
SQL Server 2008 RTM - Maintenance Plans need Integration Services installed
The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...
2017-01-31
900 reads
#ReadyRoll at #SQLintheCity
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source...
2017-01-30
784 reads
A New Year, A New Company and A New DenverSQL Chapter
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into...
2017-01-30
636 reads
Altering Data Length of a Primary Key Column
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
935 reads
Azure quick start
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
676 reads
Creating a connect entry.
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,117 reads
Enabling Remote Access to the Dedicated Admin Connection
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to...
2017-01-30
2,935 reads
Monday Coffee 2017-01-30
Wow, what a week last week was.
The biggest thing that happened was that I got a session at SQL Saturday...
2017-01-30
565 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