My latest presentations
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2018-02-26
669 reads
Off to SQL in the City 2018
I’m off today on a plane, flying to the UK for this Wednesday’s SQL in the City broadcast. This is...
2018-02-26
334 reads
GDPR: Your Hair Is Not On Fire
Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...
2018-02-26
485 reads
How to setup Azure SQL Analytics
I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...
2018-02-26
1,073 reads
Double hop error when using SQLCMD
tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.
One of the problems with linked servers (no rude noises please)...
2018-02-26
2,121 reads
My experience with TechOutbound 2018 – Caribbean
I am a passionate, regular attendee of Techoutbound (formerly SQLCruise) events. I try to do at least one every year. ...
2018-02-26
383 reads
SQL Server Tune Your Transaction Log
Whenever a transaction log file grows the space it is allocated is divided up into virtual log files (VLFs). Depending...
2018-02-26
106 reads
The Data Platform has expanded – so too should our approach in using it….
In recent years we as data professionals have moved from dealing with SQL Server databases with SQL Server Reporting Server...
2018-02-26
502 reads
Change the name of master database files – SQL Server on Linux
In my recent blog, I discussed about how to move master database to another location. One of the readers requested...
2018-02-26
752 reads
Stop Worrying About Index Fragmentation and Manage Your Statistics
I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive...
2018-02-25
85 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
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...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers