Legacy Limits
Sometimes the hardware or software we use prevents upgrades, which isn't necessarily good for any of us.
2017-01-20
85 reads
Editorial
The (Former) Complexity of PowerShell
Steve Jones notes that PowerShell seems to becoming an easier to use language for SQL Server professionals.
2022-03-09 (first published: 2017-01-19)
430 reads
2017-01-18
209 reads
Delaying Patches is Problematic
Many of our security issues come down to not patching software when there are updates available.
2017-01-17
130 reads
Writing the Correct Query is Important
Making simple mistakes in queries can have far reaching consequences.
2017-01-16
183 reads
The Development Lab
This week Steve Jones looks at hardware and the ways in which you might assemble a set of computers for building software.
2017-01-16
68 reads
Securing Your Instances
This week Steve Jones looks at moving the port numbers of your instances for a bit of security.
2022-11-25 (first published: 2017-01-13)
220 reads
Backup Data Security
We need better security for our data, especially for our choices in managing data.
2017-01-12
90 reads
2017-01-11
181 reads
SQL Server is Getting More Popular
Today, Steve Jones looks at the popularity of SQL Server, which was named DBMS of 2017.
2017-01-10
144 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