Backing Up Your Old Systems
I am currently on a project to review some older servers (SQL 2000 and 2005) for SIMPLE recovery (and therefore...
2012-02-16
399 reads
Nebraska SQL from @DBA_ANDY
Meme 15 - LinkedIn
The #Meme15 assignment from Jason Strate (Blog/@StrateSQL) for February is to describe how and why we use LinkedIn. I felt...
2012-02-15
392 reads
SQLRockstar's SQL Someday
http://vimeo.com/33411604
This is a talk given by Thomas LaRock (@SQLRockstar to you Twitter-folk) at an event last fall in NYC called...
2012-02-15
377 reads
Meme Monday - What I Want for Christmas from Microsoft
This Christmas if I could get one thing from Microsoft it would be recognition that DBA's are not developers. This...
2011-12-05
742 reads
Going to PASS 2012!
As I have previously written about in this space, I have recently moved to House of Brick Technologies. Part of...
2011-11-15
375 reads
The Industry Problem according to @Way0utWest
Steve Jones (blog/@way0utwest) from SQLServerCentral posted his daily editorial today titled "The Industry Problem" in which he describes an article he...
2011-11-14
1,017 reads
Why is -fill in the feature- Enterprise-Only?
Steve Jones (Blog/@Way0utWest) recently wrote a great blog post proposing that Microsoft should go from having edition-only features (most of...
2011-10-21
430 reads
Moving to House of Brick
Starting Halloween Monday I will be a Technical Consultant for House of Brick Technologies.
To everyone out there saying "Didn't you...
2011-10-19
514 reads
Blogs
2 Tips to a Working Schedule
By Brian Kelley
When I watched the following video from Justin Sung, I realized that I am...
Monitoring SQL Server Performance with the Pure Storage FlashArray OpenMetrics Exporter
I’m excited to share a new open-source project I’ve been working on that combines...
Teaching at the SC Statewide Audit Conference
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Forums
Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI
Comments posted to this topic are about the item Why Clone Fails: Discovering the...
A Well Deserved Break
Comments posted to this topic are about the item A Well Deserved Break
Multiple Defaults
Comments posted to this topic are about the item Multiple Defaults
Question of the Day
Multiple Defaults
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers