Evaluating Life at Work
It can be hard to evaluate your career and job situation, but Steve has some ideas today.
Can I Offload DBCC CHECKDB To Another Server?
You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing a good job. Who’s a good dog? You are! Good dog.
What is the impact of remote working on estate management?
Distributed workforces have very quickly become the norm. The 2020 State of Database Monitoring survey explores the impact of remote working on estate management and how organisations are responding. You can read the full findings in the free report, here.
Provisioning Azure SQL Database with Failover groups using Terraform
Get a basic introduction to Terraform by deploying and removing SQL Servers and a failover group to Azure.
Why Billing Will Be Part of Our Job
I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are charged in the cloud. It was a mess, and individual departments had to answer for excessive charges. I don't know that any department ever lost service, […]
Hands-On with Columnstore Indexes: Part 1 Architecture
Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be wondering why they are different than traditional indexes and how they work. In this series, Edward Pollack explains the architecture of Columnstore indexes. In future articles in the series, he will describe best practices for Columnstore.
Unlocking the value of frequent database deployments
Database deployments are on the rise, with more organizations releasing weekly or daily. But this does not always result in more value being delivered. Steve Jones advises the steps you can take to unlock the value of frequent releases in this blog.
Monitor Deadlocks in SQL Server with system_health Extended Events
In this article we look at how to find SQL Server deadlocks using the system health Extended Events session.
Take our short readers’ survey and win a $50 Amazon voucher
Could you spare 3 minutes to help us out at SQL Server Central? Take this short survey, tell us about who you are and why you come to SQL Server Central, and you could win a $50 Amazon voucher.
Do You Still Want Coping Tips?
A simple question, and you can vote by leaving a comment for this article. Do you still want me to include the coping tips in the newsletter after June? When the pandemic shut down much of the world in March, our CEO at Redgate Software asked us to think about what we could do to […]
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU MENARA BIDAKARA Telp:0821-8200-203
Telp/WA 62 821-8200-203 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
BCA KCU KEBAYORAN BARU Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
BCA KCU PONDOK INDAH Telp:0821-8200-174
Telp/WA 62 821-8200-174 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers