Search for a Value Throughout Your Database
Learn how to search for a value throughout all database tables.
The Gambler
If you are the type of person that doesn't run DBCC checks, Steve Jones thinks you're a gambler. And you might think about attending SQL Intersection next month in Vegas.
An Incremental Database Development and Deployment Framework
Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.
An Orders of Magnitude Problem (T-SQL Tuning)
When a query suddenly starts taking much longer, what do you do? This story from Jerry
Resetting DMVs
Steve Jones asks the question why so much data in SQL Server is cleared when we restart an instance.
Getting Started with Extended Events in SQL Server 2012
Extended Events provide a way of unintrusively monitoring what's going on in a SQL Server instance. Unlike SQL Server Profiler and SQL Trace, it has little performance impact. Now, in SQL Server 2012 SSMS, it is relatively easy to use, as Robert Sheldon shows.
Help Guide the Future of SQL Compare
How changes are applied to databases differs from person to person and from organization to organization. Here at Red Gate we’re writing the next chapter for SQL Compare and we need your feedback to validate some of our ideas. To help us in this endeavour, and to enter a prize draw for one of five $50 Amazon vouchers, please complete the following survey.
Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
Data Mining Introduction Part 3: The Cluster Algorithm
This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.
Self Describing Databases
Today Steve Jones gives his vision of the database in the future. He hopes that databases contain more information about not only their objects, but their needs, like backups and maintenance.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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 ...
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