Helping Streamline Log Shipping Failovers
Using Log Shipping? Looking for a more automated way to fail over during a disaster? Read on...
2013-12-03
1,662 reads
Articles
Lessons Learned from Six Years of Agile Database Development
Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a reality, without disrupting users. He explains how this allowed his team to apply an iterative, evolutionary approach to the design and development of their databases, as well as applications.
2013-12-03
11,349 reads
SQL Monitor Metric: Processes in a runnable state (scheduler query)
Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.
2013-12-03
3,671 reads
High-Performance Transact-SQL with Window Functions
Window functions are more intuitive and simpler in many cases than alternative SQL methods.
2013-12-02
8,778 reads
Getting Ready for Big Data: Prepping the Data Warehouse
Big Data implementations bring their own problems and issues, and will require database administrators and support staff to redesign the data warehouse architecture. Here's how.
2013-12-02
4,609 reads
More Tips for New (and old) DBAs
Following up on the popular article: Tips for New DBAs, author Craig Outcalt tackles three more issues including customer support and why you should learn T-SQL.
2013-11-29 (first published: 2009-01-12)
25,798 reads
Workaround for lack of support for constraints on SQL Server Memory-Optimized Tables
SQL Server 2014 offers In-Memory OLTP, but you may be hesitant to use this because of the lack of support for constraints on Memory-Optimized Tables. In this tip we will see how we can solve these issues.
2013-11-29
3,860 reads
Test-Driven Development of T-SQL Code
Learn how to incorporate Test-Driven Development practices into your database development methodology with TSQLUnit.
2013-11-28 (first published: 2008-10-20)
20,332 reads
SQL Saturday #264 - Ancona, Italy
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Dec 13 2013 at Università Politecnica delle Marche - Ancona, Italy. This SQL Saturday will feature 3 tracks focused on BI, DBA, and Development.
2013-11-28
2,464 reads
T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses
A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.
2013-11-28
6,824 reads
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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
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...
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