Rebuild System Databases
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...
2012-01-29
3,352 reads
Blog Posts
Creating merge replication conflict alerts
One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in...
2012-01-28
1,528 reads
January #Meme15 Round-Up
The second round of #meme15 finished up last week and it’s time to see who participated. In total, there were...
2012-01-28
796 reads
Petitions on Change.org and Thoughts on Changing PASS
I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a...
2012-01-28
789 reads
Blogging: Building a Blog
I took an interest in building a blog/website several years ago when I first started my company and working for...
2012-01-27
737 reads
Deadlock Monitoring
There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...
2012-01-27 (first published: 2012-01-23)
3,082 reads
2012-01-27
701 reads
Microsoft Data Appliances Help Simplify MSBI Projects
As some of you know, I am really excited about the data appliances Microsoft and HP have released this year. ...
2012-01-27
632 reads
Re-blog – January 20 – January 26
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-27
541 reads
SQL Server - Generate SQL INSERT from Excel
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY...
2012-01-27
1,071 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers