Cursors for T-SQL Beginners
Should we really avoid cursors? See how to rewrite code to avoid cursors and also analyze the implications.
The Backup Passwords
Today Steve Jones asks how you handle those passwords across time for backups in this week's Friday poll.
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.
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.
Greed Is Good (for IT)
Can greedy executives be good for IT? Steve Jones thinks so and gives us a few reasons today.
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.
SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA
Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software.
This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.
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.
Treat People Like People
Steve Jones thinks that the Millennials have the right approach to work. There are many things that are more important than money.
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.
Blogs
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 ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
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