SQL Server Database engine patching
This script can install Service pack, security patch and Cumulative update on SQL instance(Database Engine).
2020-05-26 (first published: 2020-05-19)
1,161 reads
This script can install Service pack, security patch and Cumulative update on SQL instance(Database Engine).
2020-05-26 (first published: 2020-05-19)
1,161 reads
This post on SQL Server patching illustrates a quick and simple way of safely extracting SQL Server installation files in advance of patching a SQL Server instance.
2016-04-05
3,664 reads
Not sure if this is it but, your cursor should be declared STATIC since the underlying data is being modified during execution. STATIC ensures a buffered copy is used for the cursor loop. Try: DECLARE prob_cursor CURSOR STATIC LOCAL FOR ...
2004-10-07
More information on how to setup and secure Reporting Services can be found on Microsoft's site: Reporting Services Technical Resources You'll probably be most interested in the whitepapers at the bottom of the page. As far as securing DTS packages, here is another link to look at: INF: Managing Permissions for DTS Packages in an […]
2004-10-04
The bulk load process described by David has advantages, but the one issue I see is that the select distinct part filters duplicates from the load batch without respect to the existing data in the target table. If the original "duplicate" row is existing data then that step will still fail with a unique constraint […]
2004-09-27
oh joy... can't wait to do my move at the end of next month...luckily for me, I will also be moving the 400lb dell rack with my 3 servers, kvm, 2 switches, 19" monitor and various other ... stuff double the estimate and add 2 hours... could do that.. I prefer the "42" estimate. No […]
2004-09-24
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers