New Database Job – The 6 Month Plan
So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects
The post New Database Job...
2022-12-19 (first published: 2022-12-01)
284 reads
Blog Posts
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
442 reads
What is TDE (Transparent Data Encryption)?
TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...
2022-12-19
78 reads
Creating a user for a STONITH resource in vSphere
I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...
2022-12-16 (first published: 2022-12-01)
95 reads
Daily Coping 16 Dec 2022
Today’s coping tip is to send a gift to someone new. I have been sending gifts to my daughter at college every month or so, but I decided I...
2022-12-16
12 reads
My Office Setup
At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...
2022-12-16 (first published: 2022-12-01)
285 reads
Daily Coping 15 Dec 2022
Today’s coping tip is to support a charity or cause you care about. My big causes are food, housing, and education for those that are struggling. I like to...
2022-12-15
14 reads
End of year planning: T-SQL Tuesday #157
It’s T-SQL Tuesday again! And Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the ... Continue reading
2022-12-15 (first published: 2022-12-13)
47 reads
My presentation recordings of data architectures
Over the years I have presented a ton (see the list), and some of those presentations were recorded. I had put some of them on my YouTube channel, but...
2022-12-15
9 reads
Daily Coping 14 Dec 2022
Today’s coping tip is to offer to help someone who is facing difficulties now. I’ve been very lucky in life. I find that success often has me associating with...
2022-12-14
10 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
SQL Server Maintenance Plan Feedback
Hi I set this up today. I wanted to get some feedback. I have...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint)) , BIT_COUNT (CAST (-1 as bigint))See possible answers