Ever have problems following something from Books Online? There may be a reason. Microsoft has noticed as well and there are updates for this valuable DBA tool. Here's a sample of the changes and a link to get the update.
2002-10-21
4,442 reads
What's this error:Arithmetic overflow error converting IDENTITY to data type int? It was a new one to me, but read on to find out what it means.
2002-10-14
6,921 reads
How secure are your SQL Servers? Are they patched? Are you aware of all the patches and vulnerabilities out there? This new tool from NGSSoftware can help you answer these questions and keep your environment secure.
2002-10-08
5,161 reads
Steve found a gaping hole in his backup process. One that he plugged with this script to move log files around the network in the event of a server failure. If you can't afford to lose a day of work, read about his solution.
2002-09-30
6,266 reads
Ever needed a pause in a script? Maybe want to retry something after a minute? This article gives a quick snipped of code that will help you implement a pause in your script.
2002-09-26
6,944 reads
Having trouble with a target server (TSX)? Steve Jones did in his environment. Read about how he worked around the issue to restore administrative capabilities.
2002-09-16
7,233 reads
It's been a year since Steve Jones last wrote about the state of the DBA job market after the economy soured. Here's an update of the last year.
2002-09-09
4,486 reads
Part 4 examines more ANSI options that are available in SQL Server. A simple setting with some unexpected (for the author) results.
2002-09-03
4,741 reads
How many of you are VB programmers? How many of you have never worked with DMO? This is the article if you don't work with VB or DMO, but want to get started. One of the more powerful tools that you can add to your arsenal.
2002-08-29
12,732 reads
A new SQL Authentication password cracker you should be aware of. It can crack your SQL passwords and give you an idea of how secure you are.
2002-08-20
18,037 reads
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
Hi All, Is there any query using which we can tell what is the...
Hi everyone I am working on a SSIS package where I am automating data...
Comments posted to this topic are about the item Review Early and Often
Ask SSC