SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)
SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008
2011-05-30 (first published: 2008-05-05)
22,533 reads
Articles
TSQL Challenge 57 - Identify rows that match the rollup trade data
Your job is to scan the trades data and identify combination of trades that match a given rollup data.
2011-05-30
897 reads
Cartoonists Wanted
An open call to the amatuers that might want to pen some database related cartoons for Simple Talk Publishing.
2011-05-27
1,795 reads
Cursors for T-SQL Beginners
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
2011-05-27 (first published: 2009-01-01)
23,294 reads
Onboarding SQL Server Private Cloud Environment
This guide outlines the major considerations that must be taken into account when onboarding Microsoft® SQL Server® environments into a private cloud infrastructure.There is a strong trend in IT to virtualize servers whenever possible, driven by:1. Standardization2. Manageability3. IT agility and efficiency4. Consolidating servers reduces hardware, energy, and datacenter space utilization costs5. Virtualized environments allow new Disaster Recovery strategiesThe Hyper-V™ role in Windows Server® 2008 R2 provides a robust and cost-effective virtualization foundation to deliver these scenarios.However, there is significant risk in virtualizing SQL Server environments without giving careful consideration to the workloads being virtualized and the requirements of the server applications running on a Hyper-V environment.
2011-05-27
1,919 reads
Getting the most out of your SQL Server 2008 Cluster
Gain an insight into how to use your SQL Server cluster for more than just high availibility in this article from Mark Jones.
2011-05-26
3,912 reads
SQL Server Index Maintenance Performance Tuning for Large Tables
This article describes a real-world example of performance tuning index maintenance for a large table of approximately 1 billion rows.
2011-05-26
5,252 reads
Nominations open for Exceptional DBA of 2011
The Exceptional DBA contest is running again in 2011 and nominations are now open. Please submit yourself or a colleague for a chance to win some great prizes and be recognized as an amazing data professional.
2011-05-25
531 reads
TIME Gentlemen please! The SQL Server temporal datatypes
If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to the more standard datatypes that were introduced in SQL Server 2008. Joe Celko explains why, and walks through some of the history of the TSQL way of storing and manipulating dates and times.
2011-05-25
3,801 reads
Parsing Log Files and Summarizing Results with PowerShell
This article takes a look at how PowerShell can speed up the process of parsing large log files.
2011-05-24
8,952 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers