Welcome to The Monday Morning DBA
I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...
2017-09-30
352 reads
Blog Posts
Adding a Replica back into a SQL Server Availability Group
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-29 (first published: 2017-09-25)
2,722 reads
Friday Reading 2017-09-29
Another busy week almost over and today I’m heading to Utrecht for SQL Saturday Holland! Never been to Utrecht before...
2017-09-29
505 reads
Love and Hate for SSMS
People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings...
2017-09-29
16 reads
SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date...
2017-09-29
78 reads
SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,712 reads
Stop waiting for SQL Server Service Pack 1 before upgrading!
It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...
2017-09-29
766 reads
Test Database Compatability with dbatools
I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and...
2017-09-29 (first published: 2017-09-20)
2,197 reads
All Day DevOps–A Free, Virtual Conference
All Day DevOps is coming on Oct 24. This is a 24 hour event, with 100 sessions live, online. You...
2017-09-28
1,311 reads
Ask HN: Would you run SQL Server on Linux?
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
573 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers