SQL Server Principals – Back to Basics
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
Related Posts:
Easy Permissions Audit January 21, 2019
SQL...
2016-01-28
423 reads
Blog Posts
Using SQL Server Change Tracking for Incremental Loads
Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started...
2016-01-28 (first published: 2016-01-20)
3,000 reads
Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,037 reads
Easy Installing .NET 3.5 for SQL Admins
Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.
This is a common problem and relatively easy fix for...
2016-01-27 (first published: 2016-01-21)
1,466 reads
Migrate from on-prem SQL server to Azure SQL Database
This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.
In...
2016-01-27
1,156 reads
Querying Deadlocks From System_Health XEvent
It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is...
2016-01-27 (first published: 2016-01-25)
2,913 reads
The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
504 reads
Change Availability Group Endpoint IP
I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s...
2016-01-26 (first published: 2016-01-14)
1,536 reads
Does an index scan always read the entire index?
No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...
2016-01-26
511 reads
Microsoft & R Programming Session Materials & Resources Available
Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power...
2016-01-26
1,024 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers