Giving Back – #TSQL2sday
T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...
2014-12-09
788 reads
T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...
2014-12-09
788 reads
Having a Change Log is a good thing. A quick and simple place to find out what has changed on...
2014-12-16 (first published: 2014-12-08)
5,145 reads
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...
2014-11-28 (first published: 2014-11-24)
6,786 reads
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...
2014-11-28 (first published: 2014-11-18)
7,137 reads
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,401 reads
I have a lab on my laptop running various servers so that I can problem solve and learn and recently...
2014-11-05
542 reads
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...
2014-11-04
4,892 reads
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
700 reads
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...
2014-09-09
724 reads
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
520 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers