It Is Your Fault
I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my...
2013-02-27
1,532 reads
Finding SQL Server Installs Using Powershell
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,450 reads
A Month of PowerShell – Day 27 (Scripting SQL Objects)
Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-11 (first published: 2013-02-27)
3,481 reads
Setting up an Internal Friendly URL
Note: This solution is not necessarily the best or most efficient solution in all cases. It is, however, very simple...
2013-02-27
3,309 reads
Thanks to my session attendees
To all of the wonderful attendees to both the VMware Partner Exchange SQL Server on VMware VBCA boot camp on...
2013-02-27
1,103 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
14 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
16 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4...
2013-02-26
1,310 reads
Get Database information in mail using PowerShell !
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would...
2013-02-26
1,940 reads
SSRS 101 – Creating a Shared Dataset
Now that you have created a Share Data Source, it’s time to add some data to your project. In this...
2013-02-26
2,887 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