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
852 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
874 reads
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
1,002 reads
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
464 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,440 reads
Virtual Lab – Adapter Setup
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-03-06
1,072 reads
The weakest link in database security
The weakest link in database security is the same as for most all IT security: people.
Because the weakest link is...
2014-03-06
958 reads
How wait statistics are generated
In our last article “Why wait statistics are important and how you can start collecting them now!” we discussed a...
2014-03-06
696 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,174 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,305 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers