Changing physical locations of all DBs
I got a request this week from an application engineer. The request was to move ALL physical database files from...
2019-03-25 (first published: 2012-07-02)
4,428 reads
I got a request this week from an application engineer. The request was to move ALL physical database files from...
2019-03-25 (first published: 2012-07-02)
4,428 reads
SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more
about SQL Server and network with the...
2015-07-21
3,677 reads
SQLSaturday
is a full day FREE training event for SQL Server
professionals and those wanting to learn more about SQL Server and network with
the SQL Server...
2014-09-18 (first published: 2014-09-16)
6,356 reads
Welcome to SQLSaturday #250 in Pittsburgh
http://www.sqlsaturday.com/250/
SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more about SQL...
2013-09-05 (first published: 2013-09-03)
1,291 reads
One of my previous posts, I covered how to create a really big database with just garbage data in it....
2012-12-29
1,131 reads
It's been an interesting day. It was the 1 year anniversary of SQLSandwiches today. It was also my last day working...
2012-03-16
1,071 reads
This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery...
2012-01-29
11,804 reads
Without looking, name your most important server. Or if you have a bunch, name the top 2 or 3.
Now tell...
2011-12-04
918 reads
It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...
2011-09-14
2,305 reads
I was unable to go to TechEd this year but I did get a chance to hit up Code Camp. It...
2011-08-29
917 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers