MVP Andy Warren continues his series of videos on auditing with a look at removing old data. In this video, learn how to develop an easy system to keep a rolling history, removing anything older than a set number of days.
2009-03-12
1,813 reads
Question: Why is my mirror database in a restoring state? Hi, I am still working on DB mirroring with prinicpal and mirror. There will be no Witness. This is what I did and
2009-03-12
12,087 reads
This article is the first in a series of articles that will be covering all the Control Flow Tasks and Maintenance Plan Tasks in SQL Server 2008 Integration Services
2009-03-12
2,275 reads
A tip from MSSQLTips that shows a few ways for implementing paging on large tables.
2009-03-12
5,878 reads
There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs will often initiate a request, but are not normally trained in the arts of influencing the management decision process to ensure that essentials get purchased. It is becoming essential to understand how to get Management support for software purchases. Dan offers nuggets of wisdom.
2009-03-11
2,005 reads
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
2009-03-11
62 reads
As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.
2009-03-11
62 reads
The other day I was wandering around Best Buy and noticed that they had a few netbooks for sale. I stopped by because I've considered using one for presentations and some light travel, instead of lugging around my full sized notebook. Vacations, maybe...
2009-03-11
3,430 reads
Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.
2009-03-11
2,147 reads
Learn the basics of how to audit changes on your SQL Server with MVP Andy Warren.
2009-03-10
5,696 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Telp/Wa 628218200233 Komp, BSD City, Ruko Barcelona, Blk. E9 No.30 RK No. 28, 29,...
Telp/Wa 628218200203 Jl. Raya Pemda Blok R-1 No.07, dan No.08, Bojong, Kec. Cikupa, Kabupaten...
Telp/Wa 628217555651 Jl. Borobudur Raya Blok M No. 36-37, Bencongan Indah, Kecamatan Kelapa Dua,...
How many types of DML triggers are there?
See possible answers