SQL 2012 Identity Columns Feature
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...
2016-02-25
1,459 reads
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...
2016-02-25
1,459 reads
The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales...
2016-02-25
612 reads
SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while,...
2016-02-25
1,124 reads
[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...
2016-02-24
23 reads
[read this post on Mr. Fox SQL blog]
I had a question at work recently where there was some confusion around how SQL...
2016-03-02 (first published: 2016-02-24)
2,713 reads
Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.
I saw Rob Farley build a...
2016-02-24
1,335 reads
Database Level Permission
DECLARE@DBuser_sql VARCHAR(4000)DECLARE@DBuser_table TABLE(
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200))SET@DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,
USER_NAME(b.role_principal_id) AS AssociatedDatabaseRole
FROM [?].sys.database_principals a
LEFT OUTER...
2016-02-24
643 reads
No, Superdome X is not the name of the stadium where they played in the last Super Bowl. Rather, Superdome...
2016-02-25 (first published: 2016-02-24)
1,301 reads
One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be...
2016-02-24
634 reads
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...
2016-02-24
1,089 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers