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.
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
Kimball University: A Data Warehousing Fitness Program for Lean Times
How can you do more with less? Follow this data warehousing/BI strengthening regimen to cut cost, avoid expenditures and bulk up the bottom line.
PASS 2009 Summit - Call for Speakers is Open
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...
A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
Do DBAs Still Read Technical Books?
Despite my misgivings about the fall from favor of technology books, I was heartened to hear from the developers at Red Gate that the classic books on the art of programming are still important to them. What are the equivalent books for DBAs?
Super Quick Table Meta Data
Learn how to get column names, data types, indexes, foreign keys, triggers and more in one snappy overview from new author Jacques Bosch
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers