SQL Homework – July 2017
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...
2017-07-03
413 reads
24 Hours of PASS, Summit Preview Session
I’m proud to announce that I’ve been selected to present a session in this year’s 24 Hours of PASS: Summit...
2017-07-03
349 reads
Creating the SSIS Catalog
If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually...
2017-07-03
705 reads
Building Always On Availability Groups - Part 1
Introduction
By David Postlethwaite
Ensuring that your databases can survive a major outage such as a server failure and can continue to...
2017-07-14 (first published: 2017-07-03)
2,197 reads
Monday Coffee: Alerts & Checks
Hope you all had a good weekend, the Lions won so I’m pretty happy.
Over the weekend I was thinking about...
2017-07-03
360 reads
Update SSMS With PS1
With how many updates are coming out I threw together a script to parse the latest version from the webpage,...
2017-07-12 (first published: 2017-07-03)
1,628 reads
Capture Important Parameters of the SQL Server Replication
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,709 reads
Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,962 reads
Don’t Forget the Keys
I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server...
2017-07-11 (first published: 2017-06-30)
2,228 reads
Using Organization Hierarchies as Reporting Unit filters with Management Reporter
Well, hello. It has been more than three years since my last blog, since then I have been really busy...
2017-06-30
593 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers