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
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
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
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
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
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
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
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
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
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
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
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