Why Don't You Upgrade in Place?
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
6,150 reads
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
6,150 reads
A lesson learned when trying to restore backups with standby. You can't upgrade versions.
2023-09-25
10,083 reads
Monitoring your SQL Server is important. This article examines one of the metrics you might want to keep an eye on.
2021-02-26 (first published: 2019-02-26)
47,615 reads
A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” was low! This article presents one way to solve the challenge by […]
2020-04-27
1,780 reads
Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to you!
2016-10-11
1,817 reads
It’s still a bit hard to believe that SQL Server will soon run on Linux. If you think back to the early days of SQL 7, 2000, even 2005, who would have bet any money on it ever happening?
2016-04-01
2,222 reads
I became a SQL guy back in 1998 because the company that hired me used SQL Server. It’s been a good ride and it’s paid the bills, but after 15 years or so it’s time to do something different.
2015-04-01
6,297 reads
In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters.
2014-03-31
3,135 reads
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
2013-12-23
165 reads
If you’re involved in the database world it’s hard to have missed the rise of the “no-sql” database products, designed to – depending on your view or the product I suppose – make databases simpler, break out of the transaction database paradigm, scale out across hundreds of machines, make it easy to change the db design (or not require one). I think some of the problems no-sql tries to solve are real, others reflect a lack of awareness/training/tools on how and why relational databases could not just solve the problem, but solve it better.
2013-04-01
3,528 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers