Database Compatibility Level 101
Each SQL Server database has a setting called Compatibility Level that determines how T-SQL commands are interpreted and what features...
2015-04-12
1,753 reads
Blog Posts
SQL Server 2014 Upgrade Sessions on the Microsoft Virtual Academy
It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios...
2015-04-12
444 reads
SQL Server 2014 Upgrade Sessions on the Microsoft Virtual Academy
It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios...
2015-04-12
174 reads
A full day with me, SSIS, and Edgar Allan Poe
When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there...
2015-04-10
626 reads
Big Data Hackathon in Microsoft Canada: Power Map will find your way!
Big Data, what a term! Some people instantly think of a huge sometimes cumbersome volume of information, others define it...
2015-04-10
1,640 reads
2015-04-10
1,123 reads
I Am Grateful For
I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts...
2015-04-10
535 reads
In-Memory OLTP: Part 1 – Introduction
In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly?...
2015-04-10 (first published: 2015-04-06)
848 reads
On PowerShell
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
679 reads
On PowerShell
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
417 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