Auditing Your SQL Server - Part 1
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
2003-02-24
13,133 reads
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
2003-02-24
13,133 reads
Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.
2003-02-21
10,020 reads
Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.
2003-02-20
13,084 reads
Ever wanted to know how to reuse identity values after they're deleted? In this example by Dinesh, he shows you two methods to reuse the wholes in identity rows.
2003-02-18
8,664 reads
Steve Jones recently got bit by a bug the reminded him of the Y2K fiasco. Read about the problem and how Steve solved the problem.
2003-02-17
4,612 reads
These sets of scripts will add minimum password enforcement when a login is created or its password changes.
2003-02-14
135 reads
Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!
2003-02-14
8,383 reads
This article by new contributing member Bob Musser shows you how to reduce the amount of scans that SQL Server Agent does against databases. Not for the faint of heart.
2003-02-13
4,950 reads
An interview where they discuss their data strategy and integration with Visual Studio .Net
2003-02-12
3,288 reads
Although there are legitimate reasons for using filegroups, Chad Miller recently encountered a situation where they were used too much. He shows you in this article why and how to remove excessive filegroups.
2003-02-11
12,193 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers