Beginning T-SQL 2008 - Book Review
A book review of a new T-SQL book for SQL Server 2008, written by longtime SQLServerCentral author and MVP, Kathi Kellenburger.
2010-03-15
1,918 reads
Articles
Denormalization Strategies
In building a database, typically we want a well normalized design. However there are cases for considering options for denormalization in complex systems. Timothy Claason gives you some thoughts on the subject.
2010-03-15
11,435 reads
SQL Server Central launches online training for SQL Server Developers, DBA’s, and Analyst’s
Build your SQL Server skills without leaving your desk.
2010-03-15 (first published: 2010-03-11)
7,094 reads
SQL Server 2008 Audit Change Group
Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with.
2010-03-15
2,121 reads
SQL Server 2008 T-SQL Enhancements Part - II
Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.
2010-03-12 (first published: 2009-07-27)
29,518 reads
Log Growing Pains
Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.
2010-03-11
18,865 reads
Kimball University: Three ETL Compromises to Avoid
Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.
2010-03-11
4,390 reads
Is Your Database Application DeadLock and Timeout Resistent?
Is your application scalable under increased activity? Timothy Claason brings us a methodology for testing how your application will deal with database load.
2010-03-10
12,666 reads
Breaking Down TempDB Contention
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-10
2,763 reads
Database Activity Monitoring Part 2 - SQL Injection Attacks
If you think through the web sites you visit on a daily basis the chances are that you will need to login to verify who you are. In most cases your username would be stored in a relational database along with all the other registered users on that web site. Hopefully your password will be encrypted and not stored in plain text.
2010-03-10
3,893 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers