Scripting database objects in SQL Server 2008
In this article, we would go through the
steps to script the objects in a database using SQL Server 2008....
An Urgent Ad Hoc Report
In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.
Security Regulations
There have been calls for governmental security regulations for IT. Is that a good thing? Steve Jones comments today.
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
SQL Saturday #41 - Register and Call for Speakers
If you'll be near Atlanta on Apr 24, 2010, come to SQL Saturday #41. If you are at all interested in speaking, submit a session.
Professional Microsoft SQL Server 2008 Programming - Sample Chapter
Professional Microsoft SQL Server 2008 Programming Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical […]
Stop, Don't Panic
Your response in a crisis situation can be critical to how quickly you solve the issue. Steve Jones reminds you to stay calm in today's editorial.
T-SQL: Why “It Depends”
Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.
An overview of Master Data Services - MDS in SQL Server 2008 R2
With Master Data Services, IT organizations can centrally manage critical data assets companywide.
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers