SQL Server Management Studio in a Multi-Site Cluster
Originally posted on Clustering For Mere Mortals:
If you set up a multisite cluster (nodes in different subnets), you will...
2015-07-22
753 reads
Coffee and SQL
Continuing Series: System Center for the SQL Server DBA (SCOM Data Warehouse)
Originally posted on Blog Home for MSSQLDUDE:
Not really a new part to my multi-part series on System Center for...
2015-06-11
514 reads
System Center for the SQL Server DBA Part I: SCOM
Originally posted on Blog Home for MSSQLDUDE:
I’ll start part 1 of the Microsoft System Center series, focused on what...
2015-03-30
982 reads
System Center for the SQL Server DBA, cont’d SCOM Pack for SQL
Originally posted on Blog Home for MSSQLDUDE:
My original posting on System Center Operations Manager for SQL Server DBAs start...
2015-03-30
620 reads
2014-12-07
1,047 reads
Giving away FREE Access to my SQL Server High Availability and Disaster Recovery Deep Dive Course – Round 2
Originally posted on - Microsoft technologies and what I do for fun -:
Last year, as part of launching my very first...
2014-11-29
1,137 reads
SQL Server proxy account and local policy
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,281 reads
Taking control of the ‘sa’ account for SQL Server 2012
As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath...
2014-09-25
536 reads
A quicker way to know when DBCC CHECKDB last ran in your database.
Problem : Surely you have scheduled jobs to run DBCC CHECKDB across your SQL Servers to check database integrity. But sometimes...
2014-06-01
935 reads
Setting Up Your Custom Data Collector Set
Problem: From my previous post, we learned how to set up Data Collection in SQL Server. This is most suitable...
2014-05-21
595 reads
Blogs
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
Forums
SQL - Conditional merge join
I want to add a condition in the joining columns part of the merge...
Is there a way to implement ROWS between logic?
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
Tracking changing prices and recalculating inventory value
I'm trying to figure out a how to do average costing over time in...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers