Two methods for converting T-SQL date/time values
Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.
Happy Labor Day
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
Labor Day Bloopers
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
One Milly-yon IOPS - Database Weekly (Sept 1, 2008)
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
One Milly-yon IOPS - Database Weekly (Sept 1, 2008)
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
One Milly-yon IOPS - Database Weekly (Sept 1, 2008)
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
Un-Wired
This Friday's poll looks at vacation and how you prepare to be unwired. Steve Jones talks about some of the things you can do.
Importance of the Resource Database
This article describes the importance of the Resource database in SQL Server 2005 & 2008
Software Tool Design: Design by Sketching
Developers can get so used to relying on computers for everything that they can forget how useful it can be in the design process to elicit and refine ideas whilst working in groups, using a sketchbook, pencils and crayons. Sometimes we all need a jolt to force us to take a different approach to solving software design problems.
Summarizing Data with Aggregate Queries - SQL School Video
Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers