T-SQL Tuesday response: ways SQL professionals can grow the next generation of SQL professionals & speakers through personal connections.| SQL Tailor Consulting
Learn what the pros said about troubleshooting weird database problems in this T-SQL Tuesday Round Up by Joe Fleming.| SQL Tailor Consulting
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 Tailor Consulting
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 […]| SQL Tailor Consulting
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 […]| SQL Tailor Consulting
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 […]| SQL Tailor Consulting
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 […]| SQL Tailor Consulting