Domain Independent Cluster and Availability Group
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain independent cluster and run a SQL Server Availability Group...
2018-07-05
4 reads
Ryan Adams
Domain Independent Cluster and Availability Group
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain independent cluster and run a […]
The post Domain Independent...
2018-07-05
2 reads
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
614 reads
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice...
2018-06-19
67 reads
How to Upgrade an AG Cluster to Windows 2016
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
156 reads
How to Upgrade an AG Cluster to Windows 2016
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best...
2017-11-09
71 reads
Sync SQL Logins and Jobs
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...
2017-06-08
675 reads
Sync SQL Logins and Jobs
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...
2017-06-08
77 reads
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but...
2017-05-29 (first published: 2017-05-18)
1,393 reads
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but...
2017-05-18
88 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Calculate log space required on principle for maintenance activity
Hi all, We have a database configured for asynchronous mirroring. We have some planned...
Get a Date Time Stamp of table when another columns value changes.
I am having Below Table i want to get Result as shown in the...
how to write a query by using some filter patterns in SQL Server?
what I want is to apply some filter patterns to search the data. For...
Ask SSC