A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
568 reads
Blog Posts
A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
402 reads
Backup Database
One of the most important processes for a DBA is backing up and restoring a database. In its simplest form,...
2015-10-07
253 reads
Do you write ugly T-SQL?
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,371 reads
Exposing Deployed Event Metadata with PoSH
Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper...
2015-10-07
6 reads
Exposing Deployed Event Metadata with PoSH
In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is...
2015-10-07
516 reads
HOW WE CAN GET WHO IS CONNECTED TO DATABASE?
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
582 reads
Load Testing Your Storage Subsystem with Diskspd – Part II
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...
2015-10-07 (first published: 2015-09-29)
7,727 reads
Speaking at SQL Saturday #445 - Raleigh, NC - October 10
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
486 reads
TDE and Availability Groups
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
680 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers