Compatibility Level Confidence
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
144 reads
The database compatibility level ought to provide some protection from database upgrade changes, but do you believe that?
2020-09-21
144 reads
The script includes these steps: STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]
2020-05-22 (first published: 2020-05-13)
302 reads
The script includes these steps: STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]
2020-05-22 (first published: 2020-05-12)
710 reads
Support for SQL Server 2008 and 2008 R2 ended yesterday. Steve has a few thoughts on what you should be thinking about today.
2019-07-10
202 reads
Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you’re probably doing upgrade projects. This is a good time to ask yourself 5 questions...
2019-06-07
2018-01-26 (first published: 2015-10-15)
6,681 reads
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...
By James-Serra
I sometimes get asked from customers if they should use a star schema or...
By Steve Jones
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...
How to update check exist column by value 1 where partid exist on table...
Hello All I was tasked with setting up a new instance on the same...
Comments posted to this topic are about the item Monitor SQL Server Error Logs...