MVP Deep Dives 2 – Pre-Order
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...
2011-09-22
561 reads
Blog Posts
MVP Deep Dives 2… Pre-Order
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...
2011-09-22
499 reads
Replacing a SQL Cursor with SSIS
On a forum post recently the questions was asked how to replace a cursor with an SSIS package. This can...
2011-09-22
1,378 reads
Rows or Range, What’s the difference ?
With the release of Denali CTP3 came an extension of the over clause to allow for a sliding window of...
2011-09-22
2,316 reads
SQL Server DBA Quiz on BeyondRelational
Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web...
2011-09-22
660 reads
SQL Server Execution Plans
I writequitefrequently about SQL ServerExecution Plans. I started in that area just because that’s how you figure out what a...
2011-09-22
834 reads
SQLSaturday #85 - Orlando, Florida - September 24, 2011
Fortunately, SQLSaturday#85 stands in a class by itself - it's the only SQLSaturday scheduled this upcoming weekend in sunny Orlando, Florida.
Home...
2011-09-22
1,215 reads
SSIS version in SQL Server
Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point,...
2011-09-22
1,097 reads
SSRS – Dealing with truncating spaces
I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to...
2011-09-22
2,074 reads
An Informal Compendium of SSAS Errors, Part 1: Introduction
When practicing for my MCTS in SQL Server Analysis Services (SSAS) 2008 R2 last spring, I was shocked to receive...
2011-09-21
1,490 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