PowerSQL – Identify a Head of the Database Blocks and Generate Automated Alert across all listed SQL Instances
This is going to be a simplest way of capturing and sending some useful information via an email of ‘N’...
2013-05-06
751 reads
Last Weeks Top “Reading” Links #31
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-06
431 reads
Quick Tip: Navigating to a UNC within SQLPS
I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the...
2013-05-06
764 reads
A SQL Shirt Style For Any Occasion
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
590 reads
GO
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in...
2013-05-06
920 reads
Lost that Single-User Connection?
You have changed your database to single_user mode to do a task. As you go about your business, you lose track of which connection was the single_user connection. You...
2013-05-06
17 reads
Lost that Single-User Connection?
You have changed your database to single_user mode to do a task. As you go about your business, you lose...
2013-05-06
794 reads
SSRS 101 – Your First Report
I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL...
2013-05-06
1,388 reads
SQL Server – How to find Default data and log path for SQL Server 2012
To identify default data and log directories in SQL Server 2012 you can use SERVERPROPERTY() function. In SQL Server 2012...
2013-05-06
914 reads
2013 Carolina Code Camp Presentations
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,015 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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...
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