How To Fix OBS Black Screen when recording SQL Server Session Demo’s?
Everyone loves a demo. When I say everyone, I mean I personally love seeing a demo in a session which is why 99% of any sessions I present will...
2020-04-02
34 reads
Everyone loves a demo. When I say everyone, I mean I personally love seeing a demo in a session which is why 99% of any sessions I present will...
2020-04-02
34 reads
Background
We have recently been working on large data migration project for one of our clients and thought I would share...
2016-11-18 (first published: 2016-11-14)
1,426 reads
We all know that if you want SQL Server to push data into a table then you want to batch the...
2016-11-17 (first published: 2016-11-14)
9,482 reads
I very rarely blogabout anything other than SQL Server but felt that with a lot of the SQL Community using...
2015-08-02
900 reads
Mike and I have been extremely busy over the Xmas period and we’ve finally sorted dates for our 2015 instalment of...
2015-01-13
460 reads
During a bit of work I’ve been doing this evening for SQLRelay, I used something I have in my arsenal of...
2014-07-14
1,071 reads
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2013-12-31
1,126 reads
I had a request this morning for something I though was actually very simple:
Client: “Can you extract all data for...
2013-12-27 (first published: 2013-12-20)
6,245 reads
SQLBits in Nottingham was where it all began. A short conversation on whether there were any plans for a SQL...
2013-11-19
812 reads
As some of you may be aware, triggers are not my favourite thing in the world but like most things,...
2013-03-04
1,065 reads
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Comments posted to this topic are about the item Three Times a Day
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
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