SQLSaturday Orlando 2018 Registration is Open
We’ve just opened up registration and the call for speakers for our 12th SQLSaturday here in Orlando. We did #1...
2018-06-01
655 reads
Mobile Azure
Microsoft Azure offers up a lot of technologies that you can play around with. One thing that you might not...
2018-06-01
272 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
215 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
114 reads
Single User Mode – Back to Basics
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...
2018-05-31
309 reads
Single User Mode – Back to Basics
In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...
2018-05-31
582 reads
Power BI Data Security – Power BI Report Server
Power BI Report Server was released as a way to host reports on premises. It was one of the highest...
2018-05-31
537 reads
Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger
It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is...
2018-05-31
484 reads
Updated query to view data in the error log
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
382 reads
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne. SQL Saturday 771 (Sat 07 Jul 2017)...
2018-05-31
24 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