SQL Bite-Size Podcasts are live!
Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...
2016-03-27
269 reads
All About SQL
SQL Server Podcasts
Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...
2016-03-23
387 reads
SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
182 reads
An Extended Event script
I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...
2015-05-22
145 reads
Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
171 reads
Welcome to BlobEater
I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...
2015-03-25
302 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
166 reads
Timed SQL Server tracing
Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...
2015-02-07
243 reads
2015-02-06
191 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