An Example of Test-Driven Development, Part 5
The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.
Do You Talk Salary in the Interview?
This is a reprinted editorial from August 2, 2005. It is being republished as Steve is on vacation. Steve discusses the challenge of discussing salary in an interview.
Implicit Permissions Due to SQL Server Database Roles
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?
Extending SQL's Inherent Hierarchical Processing Operation
This article covers multipath operations that require a different hierarchical logic than SQL naturally produced hierarchical processing. These include nonlinear data ordering, the renormalization of data to remove replicated data, and the processing of network structures.
Implementing Execution Log Reports on 32-bit SQL Server 2008 R2
This article covers how to implement the SQL Server 2008 Execution Log DB and package on SQL Server 2008 R2
Windows Phone 7
Steve Jones has a pre-holiday look at the new Windows Phone 7 platform, with some thoughts on how it was designed.
Deploying Data-Tier Applications of SQL Server 2008 R2
SQL Server 2008 R2 Data-Tier Applications make database development, deployment and management much easier. When you create and build a Data Tier Application, it creates a single, self-contained unit of deployment called a DAC package. Arshad Ali shows you how to deploy the created DAC package and discusses the different methods of deployment.
Disaster Planning Includes You
Today we have a guest editorial from Andy Warren. Andy discusses the need to consider personnel when you are planning for things to go wrong.
Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server
My client wants to standardize address information for existing and future addresses collected for their customers, particularly the street suffixes. The application used to enter and collect address information has the street suffix separated from the address field, but it is a textbox instead of a drop down list therefore things are not standardized. I know there are some options out there to standarize data, but they would like a less expensive alternative. Are there any functions in SQL Server that I can use to standardized data?
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
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...
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