#SQLCareer 1/4 July 19th 2018
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-07-25
239 reads
Blog Posts
A PowerShell Pester Check for parsing SQL scripts
I like to write Pester checks to make sure that all is as expected! This is just a quick post...
2018-07-25
1,266 reads
AlwaysOn_health Extended Event Session
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
3,000 reads
Changing Your Highlight Color in SQL Operations Studio
I’ve been enjoying working with SQL Operations Studio lately – a new, free, cross-platform editor from Microsoft. The tool is under active development and it’s a great time to...
2018-07-25
9 reads
Databases and DevOps, Tools are the Easy Part
Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,066 reads
Day 2–#SQLCareer
This is a series of posts on what my day is like. I don’t do a lot of production technical...
2018-07-25
941 reads
Know more about SQL Server database backups, restores, and recovery: Q& A – Part 1
Let’s deep dive and review each of the database backup command topics to get a better understanding of what it...
2018-07-25
319 reads
Know more about SQL Server database backups, restores, and recovery: Q& A – Part 2
In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL...
2018-07-25
335 reads
Know more about SQL Server MSDB log store for database backups, restores, and recovery: Q& A – Part 3
In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do...
2018-07-25
340 reads
Patch and Update SQL Server via Command Line
No one likes to patch or update SQL Server, it takes time and can make for very long days. I...
2018-07-25
11,374 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