Posting This Week
I just wanted to do a quick post to let everyone know that I am in fact going to be...
2011-09-28
498 reads
Blog Posts
RTO in Disaster Recovery
When you have a disaster, the time that you have to restore service is usually referred to as the RTO...
2011-09-28
1,279 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!
It’s time for another SQL Saturday at the beautiful University...
2011-09-28
727 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…! It’s time for another SQL Saturday at the beautiful University of Iowa campus. The speaker lineup looks great....
2011-09-28
28 reads
SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,637 reads
SQL University SSIS : Named Pipes -- Consumer
Welcome to the third and last day of the Named Pipes seminar. Today we will get into the consumer portion...
2011-09-28
550 reads
SSIS Merge with Duplicate Rows
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,333 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,546 reads
24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
764 reads
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may have to rethink one of the answers given during...
2011-09-27
11 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers