A High Level Comparison Between Oracle and SQL Server
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
Injecting Your Own Bias
Steve Jones talks about the controversy surrounding the PASS Survey and future Summit announcements. And about how we, as data professionals, might subtly bias clients.
A little restriction that prevent changing tables in SQL Server 2008
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
SQL Saturday #29 - Birmingham
A free one day training event from SQL Saturday and the Birmingham SQL Server groups. Come join us if you are in the area.
SQL Server - Introduction to Business Intelligence Development Studio
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
Expanding The Scope of Bridge Tables
Timothy Claason continues talking about database design in a new article. This one talks about expanding the functionality that Bridge Tables provide in your schema.
Microsoft SQL Server 2008 Integration Services Problem-Design-Solution - Sample Chapter
Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.
Reverse Engineering a Server Side Trace
How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.
The Missing Certification
You can earn an MCITPro or an MCM in your DBA career, but there's a world of difference between those two. Steve Jones agrees with Simon Sabin that we need something in between.
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers