Setting Different Colors for Connections in SSMS
Learn how to set colors for different connections in SSMS.
Defusing Database Time Bombs: Avoiding the Need to Refactor Databases
Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.
Data Mining Part 26: Data Mining and Microsoft Azure
This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.
Azure Blob Storage Part 7: Snapshots
Robin Shahan introduces the concepts of snapshots in relation to Azure blob storage. She explains what they're for and how to take them, promote them, and delete them.
Database Continuous Integration workshop, Los Angeles
Redgate are hosting a 1-day public workshop on April 10th 2015 in Los Angeles, California. This workshop will teach you how to link your source control system to a build system, trigger database builds automatically, and lay the foundations for package-based deployments.
Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)
This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.
The Design Investment
How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right.
IT Compliance and Software Development
What is IT Compliance and is it really necessary for contemporary Agile applications to be constrained by the requirements of compliance? William Brewer argues that if the objective is rapid delivery of applications, then compliance controls must be understood as early as possible in development.
Limitations of MongoDb
This article looks at two critical limitations suffered by MongoDb compared with SQL Server.
SQL Server Random Sorted Result Set
In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers