Implicit Conversion Insights with XE
Seldom does a DBA have the opportunity to get out in front of infrequent or random errors such as implicit conversions. More often than not, it is the privilege...
2019-06-05
16 reads
Blog Posts
Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials (apart from the Fisher Information article, which I deliberately published out of order), I introduced...
2019-06-05 (first published: 2019-05-17)
285 reads
Microsoft SQL Server Migration plan and steps
Migration is nothing but moving a databases from...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-06-05
270 reads
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are...
2019-06-05 (first published: 2019-05-17)
227 reads
“Ups…I have deleted some data. Can you put it back?” – dbatools for the rescue
Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...
2019-06-04 (first published: 2019-05-17)
1,243 reads
CHOOSE() in SQL Server
Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...
2019-06-04
17 reads
CHOOSE() in SQL Server
Watch this week’s episode on YouTube. While I know I don’t utilize most of the features available in SQL Server, I like to think I’m at least aware that those features...
2019-06-04
310 reads
CHOOSE() in SQL Server
Watch this week's video on YouTube
While I know I don't utilize most of the features available in SQL Server, I like to think I'm at least aware that those features exist.
This...
2019-06-04
18 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week’s episode on YouTube. SQL Server’s cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query...
2019-06-04 (first published: 2019-05-21)
582 reads
Security Controls: CISA vs. CISSP
When looking at the Certified Information Systems Auditor (CISA) exam, we focus on teaching 3 types of controls: Preventative – keeps an incident from occurring Detective – Identifies the...
2019-06-04
315 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