It May Be Necessary Re-enable Service Broker After Baremetal Restore
After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...
2014-01-30
1,150 reads
Database Project Versioning
SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your...
2014-01-30
2,092 reads
SSIS Training class by Andy Leonard
Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class...
2014-01-30
1,798 reads
New SSIS Training Class from Andy Leonard
Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class...
2014-01-29
1,405 reads
Have You Studied SQL Server Enough?
Photo Credit – yum9me
SQL Server is a fairly big and complicated product. There are quite a few areas that you can...
2014-01-29
1,498 reads
SQL Server Quickie #10 – Forwarding Records
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-29
780 reads
Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern
I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more...
2014-01-29
551 reads
SSIS and PowerPivot training in Baton Rouge
I’m happy to announce that I’ll be teaming up with my Linchpin People colleague Bill Pearson for a day of...
2014-01-29
930 reads
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...
2014-01-29
1,256 reads
Master Data Services for the Beginner Part 04
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,107 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