Master Data Services (Second Edition) – Review
For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day...
2014-01-31
1,926 reads
Friday Followup For January 31, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-31
1,124 reads
My Visual Studio crashed and I didn't know why!
Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file...
2014-01-31
1,321 reads
Starting to Use Powershell
I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of...
2014-01-30
1,782 reads
Security, Compliance, and SQL Server – Recording Now Available
If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we...
2014-01-30
1,101 reads
Uninstalling SSMS on Server Breaks SQL Powershell
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...
2014-01-30
2,327 reads
Non-unique indexes that COULD be unique
In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other...
2014-01-30
1,006 reads
Final Day for Power BI Voting, Can I Have Your?
Today is the final day for the Power BI Contest voting and I could use your help to move on...
2014-01-30
1,332 reads
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,025 reads
2013 with You & SQL Server
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2014-01-30
1,131 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