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,423 reads
SQL Saturday 440 - Pittsburgh
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,676 reads
SQL Saturday #315 - Pittsburgh
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
SQLSaturday #250 in Pittsburgh
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,288 reads
TempDB Destroyer
One of my previous posts, I covered how to create a really big database with just garbage data in it....
2012-12-29
1,124 reads
1 year old sandwich
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,070 reads
Find failed SQL jobs with powershell
This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery...
2012-01-29
11,618 reads
What’s your build number?
Without looking, name your most important server. Or if you have a bunch, name the top 2 or 3.
Now tell...
2011-12-04
916 reads
How pure is your data?
It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...
2011-09-14
2,302 reads
Code Camp New Zealand 2011
I was unable to go to TechEd this year but I did get a chance to hit up Code Camp. It...
2011-08-29
913 reads
Blogs
The 5 Best SQL Course for Beginners – Reviews and Guide
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
Speaking at SQL Saturday Boston 2023
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray
In this series of blog posts, we’re diving into how to use the Pure...
Forums
temp table filtering with Joins question
Hello Gurus for one use case we converted the code to use temp tables...
checkdbcc date for all database
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
Azure Postgres reliability/management experiences
I am considering implementing an Azure Postgres DB for use in a part of...
Ask SSC