Easy Permissions Audit
Something I have written about more than a handful of times is the need to audit. When people think about...
2019-02-05 (first published: 2019-01-21)
2,569 reads
Blog Posts
Forensic Analysis on Updated Values of Database Tables to Check Any Digital Crime
SQL Server is a relational database management product developed by Microsoft. It is prominently deployed by enterprises all over the world to securely maintain crucial database in a well-organized...
2019-02-05
28 reads
I am speaking at SQLSaturday Guatemala 2019
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala city!This will be my first time as a speaker...
2019-02-05
9 reads
I am speaking at SQLSaturday Guatemala 2019
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala...
2019-02-05
155 reads
Midlands PASS Meeting for March 2019
The March meeting for Midlands PASS will be held on March 5, 2019, from 5:30-7:30 PM. Brian Kelley and Paul...
2019-02-05
132 reads
Power BI Custom Visuals Class (Module 119 – Pie Charts Tree)
In this module you will learn how to use the Pie Charts Tree. This visual allows you to view your...
2019-02-05
398 reads
Read-only tables
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...
2019-02-05 (first published: 2019-01-21)
2,658 reads
SQL Server Looking into Differential Backups
I seem to be writing solely about Azure so to shake things up a bit I am going back to...
2019-02-05
184 reads
Two T-SQL features that I appreciate
We occasionally get cool improvements in T-SQL in newer versions of SQL Server. Here’s a short post on some of...
2019-02-05
183 reads
A brief introduction for bcp
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,127 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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 ...
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers