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,440 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,684 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,361 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,300 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,144 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,082 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,981 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
926 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,315 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
923 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers