Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
2,997 reads
Blog Posts
Windows Server 2008 Cluster: Understanding the Cluster Log Behavior
In any system, logs are very important to troubleshoot the issue. In the case of windows cluster, cluster logs are...
2012-10-17
1,029 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,473 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,466 reads
SQL Server 2012 CU4 Is Now Available !
The 4thcumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update...
2012-10-16
745 reads
SQL Server 2012 RTM Cumulative Update 4
Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25...
2012-10-16
1,729 reads
SQL Server Quickie #4 – IAM Pages
Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I'm talking
about IAM Pages in SQL...
2012-10-16
1,208 reads
SQL Server Quickie #4 – IAM Pages
Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I’m talking about IAM Pages in...
2012-10-16
634 reads
SSAS #28 – Setup to Learn SSAS Stored Procedures
Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities to...
2012-10-16
1,548 reads
Thirteen Years Old
A very cool shot of our company at 13.
I first heard of Red Gate back in 2001 and they were...
2012-10-16
1,049 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