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.
In the third article in his series on styling reports, Aaron Akin takes a look at using templates to ease and speed development.
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
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
A tip from MSSQLTips that shows a few ways for implementing paging on large tables.
The Northwind database has a place in our collective hearts, despite all efforts to displace it in favor of AdventureWorks. However, a lot has happened in the past twelve or so years, and Phil Factor wonders if we can't, as a community, do better.
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.
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.
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.
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...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers