Query DB2 From PowerShell
Story time: A few months ago I was in a meeting where we were all asked how we could take on a complex, but very necessary task. As they...
2021-02-09
8 reads
Blog Posts
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 2)
It’s time for the fourth post in my series about performing regular server reviews. In the first post, we took a look at setting up your local environment. The...
2021-02-09
31 reads
Showcase Your Figma Designs on WordPress P2
Figma — one of the most popular and fastest growing digital design tools today — was recently voted “the most exciting design tool of 2021.” In many organizations, a...
2021-02-09
5 reads
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2021-02-09
184 reads
T-SQL Tuesday #135 – Awesome Tools
It’s blog party week for T-SQL Tuesday, and I think this is a good choice for a topic. The host this month is Mikey Bronowski, and his invitation is...
2021-02-09
158 reads
T-SQL Tuesday #135 – The Tools That Make My Job Awesome!
Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday....
2021-02-09
138 reads
T-SQL Tuesday #135 – Tools Used for Getting Organized
This month’s T-SQL Tuesday is being hosted by Mikey Bronowski. The subject he chose is “The outstanding tools of the trade that make your job awesome.” Tools are the...
2021-02-09
18 reads
T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome
It’s been a while since I’ve posted on a T-SQL Tuesday topic and glad to see the topic being discussed by Mike Bronowski (blog) on tools. Throughout my career,...
2021-02-09
154 reads
2020 Advent of Code–Day 1
This series looks at the Advent of Code challenges. I started the Advent of Code at the beginning of December 2020, but life quickly got in the way. Weekends...
2021-02-08 (first published: 2021-01-27)
267 reads
3 new PowerShell functions for refreshing Power BI reports on a Power BI Report Server
I just wanted to give everyone a heads-up that a new version of the ReportingServicesTools module went out last week, and it includes 3 new PowerShell functions for working...
2021-02-08 (first published: 2021-01-28)
743 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers