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,432 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,679 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,358 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,295 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,133 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,076 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,896 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
922 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,306 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
920 reads
Blogs
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Monday Monitor Tips: Looking Back in Time
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Can You Tell Why a Plan Didn’t Go Parallel?
Let’s face it, most of the time, you probably don’t want your SQL Server...
Forums
Improving the Performance of UPDATE Statements in SQL Server
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Replacing a Null
Comments posted to this topic are about the item Replacing a Null
The End of SQL Server 2019
Comments posted to this topic are about the item The End of SQL Server...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers