Hot Skills
What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.
Creating User-Defined Functions in Microsoft SQL Server
SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.
Can Wives Shorten Work Hours?
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
SQL Server's implementation of Window Functions
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
Migrating Your SQL Server Database Applications to SQL Azure
Most business applications you write probably utilize some kind of relational database. And, as a .NET developer, the chances are that database is Microsoft SQL Server. This article walks you through migrating your SQL Server database applications to the cloud with SQL Azure.
Great Service – All About Attitude
today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.
Moving Database Files Detach/Attach or ALTER DATABASE?
Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.
Mission Critical: SQL Server Upgrade
You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.
Setting up your own free Virtualized test environment
If you need to test new software, configurations, patches or operating systems, a virtual machine saves time, risk and hardware. You can set up a virtual test environment for free with some products such as VMware Server 2. All you need is a simple set of instructions about how to set it up; and here it is, thanks to Sean Duffy.
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers