PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.
We came across a scenario where database bak files being created from long time which are no more in use...
2013-04-30
1,109 reads
Installing SSMS 2012 all by it’s lonesome
SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.
Installation requires the user to download the...
2013-05-07 (first published: 2013-04-30)
26,614 reads
Enhance your career by blogging!
When I started my blog two years ago, I never would have thought how much it would help my career. I...
2013-04-30
2,848 reads
SQL Server +0 and -0
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,569 reads
Looking Forward
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,411 reads
Five Ways to Improve Your Productivity with SSMS
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and...
2013-05-06 (first published: 2013-04-30)
7,717 reads
My First White Paper – Top 10 Tips for Optimizing SQL Server Performance
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing...
2013-04-30
1,432 reads
SQLDiva reviews the First PASS Business Analytics Conference
Join Mellissa Demsak (twitter – SQLDiva) for a review of what she rates as the best from PASS’s first attempt at...
2013-04-29
1,311 reads
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...
2013-04-29
1,889 reads
INFORMATION_SCHEMA the un-sung system views
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....
2013-04-29
2,619 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