A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with...
2020-11-04
3 reads
I’ve been meaning to write something this post for a while but the stars have aligned this week. Garry Bargsley (blog | twitter) published a post about making a...
2020-10-21
2 reads
Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time...
2020-10-16
2 reads
A couple months ago I delivered a short (15 minute) presentation at work about the importance of having a good professional network and how I’d found mine. As I...
2020-10-06
3 reads
This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed...
2020-07-26
3 reads
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
159 reads
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
18 reads
Just because we aren’t all together in Houston doesn’t mean we can’t have a #SQLRun at this year’s Summit. It might even be easier for some folks as there’s...
2020-07-02
5 reads
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-06-23
20,663 reads
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-07-06 (first published: 2020-06-23)
2,546 reads
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Hi I have an overnight process that moves allot of claims records Been working...
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Comments posted to this topic are about the item Putting the Player with the...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers