SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts
We had a situation where Application owners automatically notified whenever server restarts. The SP_PROCOPTION do have a facility to perform...
2013-06-24
1,600 reads
My upcoming SQL Server Trainings
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
The 1st half...
2013-06-24
1,281 reads
Baseline SQL Server with SQL Sentry Performance Advisor
Baselines can be any set of metrics that have been recorded to give you an understanding of what is the...
2013-06-24
2,910 reads
Metadata Functions (OBJECT_NAME for example)
What is a metadata function? According to BOL a metadata function is one that returns data about the database or...
2013-06-24
846 reads
Comparing Previous Rows in SQL
I had a client recently that needed me to get the direction a student’s GPA was headed on a regular...
2013-06-24
754 reads
SQL Server – How to Enable a Disabled SQL Server Login
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
981 reads
Dynamic calculations of running totals
Dynamic calculations of running totals
A few weeks back, a friend from South Africa wrote to
me asking if I knew of a...
2013-06-24
1,303 reads
Natural Born Killers (The series) – Day 5 Key Lookups
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-24
721 reads
ASP.Net MVC Debugging "Internal Server Error 500"
I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view...
2013-06-22
545 reads
Moving a database from on-premise to the cloud – Step by Step Walkthrough
Cloud is the future and moving there is now as easy as few mouse clicks.
Today we will see how an...
2013-06-21
1,451 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