SQL Homework – May 2019 – SQLCMD and the DAC
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC ... Continue reading
2019-05-01
30 reads
Blog Posts
The case of scalar UDF inlining, where context is everything
I have a shorter post this week, but I reckon it’s an interesting story. As part of the new Intelligent Query Processing improvements introduced in the upcoming SQL Server...
2019-05-01
56 reads
Webcast: Auditing SQL Server from the Ground Up
I’m giving another webcast through MSSQLTips.com. This one is on May 9, 2019, at 3 PM EDT. It’s called Auditing SQL Server from the Ground Up. You can register...
2019-05-01
52 reads
#Operators in Python with Dominika
It’s been long time ago I published the last article. I had exams at school and worked hard to pass and have a good grades. Now I have some...
2019-04-30
31 reads
Execute SSIS Package from PowerShell
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down...
2019-04-30
39 reads
Execute SSIS Package from PowerShell
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down...
2019-04-30
15 reads
IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
9 reads
IN vs UNION ALL
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
26 reads
It’s Been a While …
Last Post – SQL Saturday MN 2018 When last I wrote, it was after I spoke at SQL Saturday in Minnesota. I co-presented a pre-con with Josh Owen. Prior...
2019-04-30
31 reads
Know How to Repair SQL Database Marked as Suspect Mode in SQL Server
Repair SQL Database Marked as Suspect Mode MS SQL server is a widely used relational database management system developed by Microsoft. It is a software product which primarily helps...
2019-04-30
15 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