Securing All Your Connections
Microsoft is recommending more security for SQL Servers, including dev and test instances. Do you agree this is a good idea? Would you implement this?
2023-06-28
208 reads
Editorials
Concurrency Challenges Around Schema Changes
A post on distributed systems and how schema changes are handled caught Steve's eye. See if you agree with how he thinks this should work.
2023-06-26
141 reads
2023-06-24
165 reads
The Reliable DBA
One of the important qualities for a database is being reliable. However, as your organization grows, you might need to ensure that your account for your people as well.
2023-06-23 (first published: 2018-03-13)
252 reads
Who's Responsible?
If mistakes are made, employees can be held financially responsible by some companies. Do we need to worry about this in our industry?
2023-06-21 (first published: 2017-08-29)
204 reads
Highly Skilled
The highly skilled people are changing and getting jobs. A recent report notes this is of concern to executives and hiring practices may be changing. Steve has a few hints for how you can grow your own career and find new opportunities.
2023-06-19
231 reads
Same Language, Different Words
I had to come to the Redgate office in Cambridge this past week for a department onsite. As a result, my wife and I were able to come early for a few days adventuring together, the first trip we've taken by ourselves in nearly seven years. As a large family with six kids, it takes […]
2023-06-17
135 reads
Free Tools, Does Innovation Matter?
Today we have a guest editorial from Brian Walker, the developer for SQLFacts. He discusses the value from his toolkit and why it can be useful for developers.
2023-06-16
278 reads
Actively Choosing Compatibility
Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.
2023-06-14
1,738 reads
Using the Lightweight Tools
This week Steve is interested in whether the newer lightweight environments, like VS Code and Azure Data Studio, are capturing your interest.
2023-06-12 (first published: 2019-12-19)
864 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers