T-SQL Tuesday #188: Growing the younger data community and speakers
T-SQL Tuesday #188: Growing the younger data community and speakers This month’s T-SQL Tuesday is being hosted by John Sterrett and asks a great question: What can we do to grow the younger data community and speakers? I think the answer lies in a personal touch. The SQL Server Community This question is very dear […]
T- SQL Tuesday #187 Round Up: Troubleshooting Weird Problems
T- SQL Tuesday #187 Round Up: Troubleshooting Weird Problems I was excited to host my first T-SQL Tuesday to find out how you solve problems. It’s a big topic, and I imagine it’s difficult to fully put to paper how your brain works, but I am thankful for the folks who did. Here’s my T-SQL Tuesday […]
SQL Server Transactional Replication – From Expletives to Excellence
SQL Server Transactional Replication Part 2, Setup and Initialization Complications This is part 2 in a series on SQL Server transactional replication. Read Part 1, Introduction and Basics if necessary. You’ve examined all the options and have decided that Microsoft SQL Server transactional replication is the solution to your problem. Congratulations! Also, my condolences. While […]
SQL Server Transactional Replication — From Expletives to Excellence
SQL Server Transactional Replication: Part 1, Introduction and Basics “I want to look at my data, and I want to look at it IN REAL TIME!” No matter how irrational or unreasonable this request is, it’s a very common one in today’s tech world. It often leads to a lot of pain as business users […]
Cursors ARE the Devil
Last month I talked about a query method that I believe is pilloried more than it should be. This month I’ll talk about a real problem I see in code frequently. If you recall last month’s blog, you may remember I talked about a company that was forced to send a public apology after a […]
NOLOCK is Not the Devil
NOLOCK is not the devil. Wow, that felt weird to say. The subject of NOLOCK hints (also known as the Read Uncommitted isolation level in SQL Server) is one that can spark very heated arguments. The arguments typically revolve around concurrency — how many processes can simultaneously access your data at once — and data reliability […]
Collaborative Database Management: Be the DBA Who Says “Yes”
What did the developer say to the DBA? It doesn’t matter; the answer is “no.”What does “DBA” stand for? “Don’t bother asking.” If you work in information technology, and maybe even if you don’t, you’ve likely heard these database administrator jokes and stereotypes. As a group, DBAs get a bad rap. After all, they’re often […]
6 Reasons Why You Should Hire a SQL Server Consultant
Why Hire a SQL Server Consultant? Almost every business accumulates data that needs to be managed and optimized. If your business has an in-house SQL Server DBA, or team of them, it might be tempting to assume they can handle all your data needs. In other words, if someone suggests you hire a SQL Server […]
Should I Upgrade My SQL Server?
Should I Upgrade My SQL Server? Why fix an element of your business that’s still running fine? Many industries run on this idea—don’t fix it until it’s properly broken. When it comes to your server, you may have a similar approach. “Why would I upgrade my SQL server now, when everything is working just fine?” […]
SQL Server Availability Groups Are Not the Solution!
SQL Server Availability Groups Are Not the Solution! That’s right. Availability groups are fairly easy to set up and can add flexibility and recovery capabilities to your SQL Server database environment, but they are not your solution. They can be your disaster without proper planning, evaluation, and implementation. Let’s take a look at some of […]