Things I Learned at Summit v20 - Trace Flag 4199
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post...
2018-12-14 (first published: 2018-11-29)
3,607 reads
Blog Posts
Change Tracking Inserts Require SELECT Permission
I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...
2018-12-13
208 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...
2018-12-13
44,311 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration...
2018-12-13
73 reads
Maintenance Plan Owner – Back to Basics
Have you ever taken over a server that had several maintenance plans on it? Have you ever really checked who the owner of those plans is? Or, maybe you...
2018-12-13
53 reads
Maintenance Plan Owner – Back to Basics
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2018-12-13
231 reads
Naming Convention Hall of Shame
Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation,...
2018-12-13
217 reads
New Resumable Online Index Create SQL Server 2019
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,262 reads
Power BI Monthly Digest – December 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-12-13
589 reads
Setting up CentOS to run docker for SQL Server
This blog post is about running SQL Server in a docker container on CentOS Linux distribution.
This was both an experiment...
2018-12-13
309 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers