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?
Decoupling the Database
Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.
Security by Obscurity
Today we have an editorial reprint from Aug 23, 2005 as Steve is on vacation. Does security through obscurity work? Steve Jones thinks it can help in a limited sense, providing another layer of protection.
Running a SSIS Package from SQL Server Agent Using a Proxy Account
Recently when I created a SQL Server Agent job to execute a SSIS package, it failed with the message "Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.". What is this exception about? What causes it and how do I resolve it?
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU THAMRIN TLP/WA 08216977701
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers