An Example of Test-Driven Development, Part 3
Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.
2010-11-12 (first published: 2009-07-13)
10,638 reads
Articles
SQL Server R2 in Luxembourg
On Nov 16, 2008, the Luxembourg SQL Server User Group will hold a SQL Server 2008 R2 event in conjunction with Microsoft.
2010-11-12
367 reads
Getting Started with Extended Events in SQL Server 2008
In a previous tip, we did an overview of Extended Events and the different components that make up Extended Events. Now that you know what Extended Events offers, how do you use it to help troubleshoot performance issues? In this tip we take a step by step look at how to implement and use Extended Events.
2010-11-12
2,644 reads
Setting SQL Server Default Locations
How to set the default locations for backups, data files, and log files in SQL Server.
2010-11-11
8,544 reads
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
2010-11-11
2,035 reads
SQL Saturday #61 - DC
A free day of training in Reston, VA, just outside Washington DC. Come join Andy Leonard, Allen White and others for some SQL Server learning.
2010-11-11
1,284 reads
SQL Server Statistics: Problems and Solutions
SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common way that things can go wrong with statistics, and how to put matters right.
2010-11-11
3,714 reads
Creating Dynamic Outputs in SSIS to an SQL Database
This article shows how you can dynamically split data based on transaction type to its own destination table using Integration Services.
2010-11-10
7,988 reads
Live Blogging from the PASS Summit
Tim Mitchell is the SQLServerCentral correspondent at the 2010 PASS Summit.
2010-11-10
353 reads
An Overview of Extended Events in SQL Server 2008
In this tip we look at Extended Events for SQL Server 2008 and how they are different from earlier tracing and troubleshooting methods.
2010-11-10
2,517 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