Contextual View
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,183 reads
DBA Fundamentals–Tuesday 11 Central–Execution Plans
WHAT: EXECUTION PLANS FOR BEGINNERS
WHEN: Tuesday, 04/17/18 - 11:00 am – 12:00 pm
WHO: Thomas LeBlanc
WHERE: https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting...
2018-04-11
597 reads
Trekking Through Formatting Forest on the #SQLPrompt Treasure Map
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-11
1,591 reads
Dates and Times in SQL Server: the science of time
Now that we have covered the various date and time data types (see the post from last time) in SQL...
2018-04-11
862 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,310 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
169 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
1,016 reads
Privacy and Protection, By Design
With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...
2018-04-11
447 reads
Free Webcast: DBA vs Memory Settings
Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...
2018-04-11
9 reads
Understanding database recovery models in SQL Server
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
777 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