DISABLE and DENY LOGIN, DENY USER & Effect on Impersonation and Permissions
DISABLE und DENY LOGIN, DENY USER & Effekt auf Impersonierung und Berechtigungen
(de)
Ein kurzer Artikel zu den Effekten – oder fehlenden Effekten...
2014-03-07
998 reads
Blog Posts
Friday Followup For March 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-07
449 reads
Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,550 reads
Reblog: February 28 to March 6
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-03-07
844 reads
Speaker of the Month, March 2014
This never gets easier. I was able to attend a bunch of sessions in the last month from a number...
2014-03-07
873 reads
A CLR Application: Deleting Three Billion Rows
In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been...
2014-03-06
1,170 reads
Approachable? Sometimes.
Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...
2014-03-06 (first published: 2014-02-25)
1,846 reads
Configuring Native Mode SSRS on local host
OK, so you successfully installed SQL Server and you selected to deploy SQL Server Reporting Services using the default installation...
2014-03-06
17,257 reads
Different approaches of counting number of rows in a table
Today, I received an email from the developer asking if there is a better way instead of the COUNT (*) Transact-SQL...
2014-03-06
1,426 reads
Dude, where’s my Power Map?
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes...
2014-03-06 (first published: 2014-02-26)
2,727 reads
Blogs
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 ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers