Shell to Script Shortcut
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
1 reads
alevyinroc
- Website: https://flxsql.com
Write It Down!
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
New Presentation - The SQLFamily
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
1 reads
Recapping SQL Saturday Albany 2020 (virtual)
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
Finding & Downloading Required SQL Server Updates
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
5 reads
Finding & Downloading Required SQL Server Updates
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
102 reads
Three Ways to Create a Temp Table
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,508 reads
Virtual SQLRun for PASS Summit 2020
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
Three Ways to Create a Temp Table
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
930 reads
Three Ways to Create a Temp Table
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
1 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers