TSQL Challenge 76 - Identify the sequence of accounting transactions
The challenge is to identify the sequence of accounting transactions.
2012-02-20
1,631 reads
Articles
How to Kill a Company in One Step or Save it in Three
The majority of companies that suffer a major data loss subsequently go out of business. Wesley David remembers vividly the day when the organisation he worked for found that they couldn't restore their data, and the subsequent struggles that ensued. Shoulda-woulda-coulda.
2012-02-20
4,949 reads
SQL Saturday #108 - Redmond
Come to a free day of SQL Server training on Feb 25, 2012 in Redmond, WA.
2012-02-20
1,565 reads
Use Dynamic SQL to Improve Query Performance
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
32,713 reads
2012-02-16 (first published: 2010-09-29)
8,655 reads
Solving a Problem Importing Integers Using Format Files
When using format files to import data into SQL Server, the Integer(INT) data type needs special handling.
2012-02-16
5,256 reads
PASS Data Architecture VC presents On Beyond Zebra AdventureWorks OR where did I go wrong?
On Thursday February 16th at 12PM noon Central, Steve Simon will discuss “No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2012-02-16
1,409 reads
What's the Point of Using VARCHAR(n) Anymore?
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.
2012-02-15
8,459 reads
A Guide to Installing SQL Server 2008 R2 Reporting Services
This document shows how to install a Microsoft SQL Server 2008 R2 Reporting Services instance.
2012-02-14
24,916 reads
Buck Woody's Cloud Howlers
We asked Buck Woody to come up with his favourite 'Cloud' Howlers. After 'Howler' monkeys, we are faced with Howler letters. Buck dreams of sending Howler letters to the folks who dreamed up the marketing hype around 'cloud' services, who misunderstand services, who don't prepares applications for distributed environments and so on.
2012-02-14
2,677 reads
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
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...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers