The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-10-01
7,587 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-09-30
47,002 reads
Midlands PASS Chapter October Meeting
Next Meeting - October 6, 2009
Speaker - SQL Server MVP Brian Kelley
Trigger Happy Database Security
In this presentation we'll look at the use...
2009-09-29
1,828 reads
One Step Closer to Being a Technical Trainer
Cross posted from The Goal Keeping DBA:
This is about a long term goal that I’ve had which isn’t posted on...
2009-09-27
919 reads
Trust Is Crucial in Security
Yesterday we were greeted to a ComputerWorld column talking about how Apple had betrayed the Enterprise's trust by having a...
2009-09-16
731 reads
First Meeting of the Charleston PASS Chapter
The first meeting of the Charleston PASS Chapter will take place Thursday night, September 17, starting at 6 PM. The first topic...
2009-09-15
736 reads
PASS Chapter Starting Up in Charleston, SC
Woo hoo! Charleston, SC is starting up a Professional Association for SQL Server official chapter. It is being started up...
2009-09-14
1,094 reads
Remember the Milk: Smart Adds
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task...
2009-09-08
989 reads
Setting Realistic Goals & Learning to Adjust
There is a lot of advice out there about how to get more done and how to accomplish one's dreams. I...
2009-08-31
2,028 reads
Quick 2005/2008 Script to Export Permissions
I had a need to export permissions to be run against the database once an older version was restored (but which didn't...
2009-08-28
13,579 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers