Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,502 reads
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,502 reads
2001-05-13
2,550 reads
2001-05-13
2,723 reads
2001-05-11
2,999 reads
Have an older workstation with only a little hard drive space? Tired of the SQL Server tools taking about a hundred megs on your most precious drive? If you answered yes to either one of those questions, then this quick tip is for you.
2001-05-11
2,821 reads
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,364 reads
2001-05-11
2,265 reads
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
16,970 reads
Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.
2001-05-10
6,408 reads
Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.
2001-05-10
6,084 reads
By Steve Jones
Recently I was trying to delete a folder and kept getting the “something is...
In the introduction of this blog post series, I explained the use case: extracting...
In the introduction of this blog post series, I explained the use case: extracting...
I tried to set the execution timeout in SSMS for SQL Server 2017 using...
Comments posted to this topic are about the item Implementing Change Data Capture
Comments posted to this topic are about the item What is new in Copilot,...
I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?
See possible answers