How to Get the Scripts for SQL Server Objects
Using VB Script allows one to script out all the Sql Server objects in independent file.
Gail Shaw: Geek of the Week
Gail Shaw, the fabled 'gilamonster', earned her MVP and the gratitude of a host of SQL Server professionals seeking technical help with her expert forum posts on SQLServerCentral. She brings great enthusiasm to everything she does, and has a huge influence on the communities she joins.
SQL Server Disasters
I joined in late to a conference call this morning from Quest where a number of their experts were talking about various disaster stories that they'd experienced over the years. It's great to hear real DBAs talking about the problems and challenges...
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
Almost Like a Service Pack
Microsoft recently laid off a number of people and made a mistake that they handled poorly. Steve Jones comments about what could have been done better.
Deploying Scripts with SQLCMD
Deploying changes to your SQL Servers can be a challenge. Longtime SQL Server expert David Poole brings us a new article looking at a solution using SQLCMD.
Using the Union Statement - SQL School Video
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
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