Getting sharper at JSON through a little experimentation.
Category: TSQL Tuesday
T-SQL Tuesday #081: Sharpen Something – Reminder
This month I am asking you to not only write a post but to do a little homework – first. In other words, plan to do something, carry out that plan, and then write about the experience.
T-SQL Tuesday #081: Sharpen Something
This month I am asking you to not only write a post but to do a little homework – first. In other words, plan to do something, carry out that plan, and then write about the experience.
SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features that I would love to see in SQL Server?
Awesome SQL Server Feature
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life much easier as a DBA.
All about the Change
The use of SQL Audit can be viable to track the changes that may be occurring within your SQL Server – from a settings point of view
Auditing Needs Reporting
No matter the mechanism used to capture the data to fulfill the “investigation” phase of the audit, if the data is not analyzed and reports generated, then the audit did not happen. With that in mind, I settled on a quick intro in how to get the audit data in order to generate reports.
One Easy Strategy for the Database Enterprise
Working with the default XEvent session and trying to make it more suitable to Enterprise worthy.
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much smaller.
SQL Server and Defaults
What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the OS has a bunch of settings […]