12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
183 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
452 reads
SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations
In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...
2017-12-26
816 reads
Different methods to write PowerShell output to a SQL table
PowerShell has become the ultimate choice for many database administrators because of its efficient way of handling and managing automation...
2017-12-26
1,356 reads
Best New(ish) SSMS Feature
Enabling the scrollbar map has saved me oodles of time - even without the preview option enabled. I can much more quickly hop to different segments of code with...
2017-12-26
7 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
147 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
1,268 reads
Creating and Using Failover Groups in Azure DBaaS – Part 2
Connecting to Failover Group
So in Part 1 of this series, we created and configured our Failover Group. Well, now that...
2017-12-26
128 reads
SQL and NOT SQL: Best of 2017
Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...
2017-12-26
428 reads
SQL and NOT SQL: Best of 2017
With only a few days left in 2017, I thought it would be fun to do a year in review post. Below you'll find some of my top 5...
2017-12-26
5 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers