Stalking the Bad Guys
What do yo do if you find malicious code in your system? Delete it? Steve Jones suggests that a honeypot might be a better idea.
Database Management for SharePoint 2010
With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There are advantages to this: SharePoint can make use of mirroring, data-compression and remote BLOB storage. It can employ advanced tools such as data file compression, and object-level restore. DBAs can employ familiar techniques to speed SharePoint applications. Bert explains the way that SharePoint and SQL Server interact.
Asynchronous Procesing with Service Broker
Service Broker is a great feature that allows you to defer processing in SQL Server. Learn how you can have processes work together, but in an asynchronous fashion in this piece from Gary Strange.
Working Long or Working Hard?
Would you rather work longer hours or tackle harder work? Steve Jones comments today on a recent post by Seth Godin. The answer as to what most people prefer might surprise you.
SQL Server Replication: Providing High Availability using Database Mirroring
This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.
A story of corrupted Master database in SQL Server 2008
This is a real-time production issue I faced with one of our clients
Competing with an MBA
If you are looking to move into management, do you need an MBA? It's nice, but Steve Jones notes that many people are realizing that an MBA doesn't necessarily prepare you to manage other people or lead them in a company.
TSQL Challenge 56 - Create a Sierpinski carpet using TSQL
This challnge invites you to generate a Sierpinsky carpet using TSQL
Wish you were here?
As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.
Space Impact of Replication Snapshot Agent Job in SQL Server
I have noticed that available disk space on my SQL Server is getting low and I see a number of files getting generated in the replication snapshot folder. Because of these files there is a space issue on my server. Why are these files here and what can I do to resolve this problem?
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers