Using Merge–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-14
980 reads
Blog Posts
Working with Very Large Tables
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,742 reads
PSDay.UK Tickets are on sale
Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we...
2017-08-13
350 reads
Building Your Brand and Becoming a Thought Leader Session Materials
Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...
2017-08-12
585 reads
DevOps Basics–Git log
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-11 (first published: 2017-07-19)
1,809 reads
Just Say No to Social Engineering Memes
These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...
2017-08-11
1,440 reads
Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
688 reads
Performance is bad. Did you change anything recently? No. Are you sure?
Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,203 reads
SQL Server vs Oracle: Convert string to date
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,210 reads
SQLskills is Giving Away Free Training!
SQLskills is giving away free training for their performance tuning and optimization classes. My entry for the competition is below. If you decide to enter for yourself, entries are...
2017-08-11
10 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