SSIS Variables and Expressions Webinar
Looks like it is that time again… for me to present a FREE webinar for good ol’ Pragmatic Works today...
2011-09-20
671 reads
Blog Posts
Statistics in Execution Plans
I was presenting on execution plans when another question came up that I didn’t know the answer to immediately. Yes,...
2011-09-20
1,356 reads
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this...
2011-09-20
24 reads
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at...
2011-09-20
903 reads
The Barking Dog Analogy
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,104 reads
T-SQL Tuesday #22 Round-Up - Data Presentation
T-SQL Tuesday #22 is history, and I was pleased by the many posts and participants in this month’s September blog...
2011-09-20
3,674 reads
Updated Data Migration Assistants (5th Version Already) & Project Template to Help with Your Upgrades
After having spent much time attempting to settle a point regarding my favourite pastime of provincial politics, it has come...
2011-09-20
1,602 reads
Building a Visual Studio project from an existing SSAS database
Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely. You...
2011-09-19
834 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t know that – you do now. It is...
2011-09-19
41 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t...
2011-09-19
1,691 reads
Blogs
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...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
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