A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-01
385 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
The case of the missing database backup file
Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...
2017-12-27
570 reads
New Features in SSMS 17.3
SSMS 17.3
SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention:
Import Flat...
2017-10-20 (first published: 2017-10-11)
4,111 reads
Stop waiting for SQL Server Service Pack 1 before upgrading!
It’s not stable until Service Pack 1…
Are you at a company that doesn’t install a new version of SQL Server...
2017-09-29
768 reads
Seattle Freecon 2017
Announcing Seattle Freecon 2017
Are you going to the PASS Summit this year? (and if not… why not?)
Are you coming in...
2017-09-28
615 reads
Working with the registry in SQL Server – adding trace flags to startup parameters
In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...
2017-09-04
776 reads
Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,759 reads
SQL Server 2016 helps with Best Practices
In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need...
2017-08-03 (first published: 2017-07-19)
4,774 reads
Combating SQL Injection
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
803 reads
Weaning yourself off of SQL Profiler (Part 2)
In a prior post, I shared a script that will take a running trace and show you the XE events...
2017-05-17
575 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