Don't Accept Defaults
All software has default values, some of which might not suit your environment. This is especially true with regards to security settings.
Tracking Business Metrics
There can be more to managing a SQL Server instance than just examining the performance metrics. There are times when understanding how your system is performing for the application is important.
Partitioning in SQL Server: Managing Sliding Window Scenario
The concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.
New and Basic Result-set Paging functionality in SQL 2012 Version.
Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.
The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow. Today's editorial was originally released on July 22, 2008. It is being re-published as Steve is at SQL Intersection.
Using Policy Based Management for checking SQL Server database file extensions
We need to exclude SQL Server database files from Antivirus and Third Party Backup Software (to make sure that files are not accessed directly). How can we be sure that all of our SQL Server file extensions are using the standard file extensions for database files?
Driving Value
Does your IT organization bring value to your company? Steve Jones takes a look at some of the ways you can do this. This editorial was originally published on July 2, 2008. It is being re-published as Steve is at SQL Intersection.
Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor
Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to analyze your SQL Server database and suggest actions to be taken in order for taking your query performance to the next level.
Automating SQL Server Database Deployments: A Worked Example
Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it through three steps by writing T-SQL scripts, adjusting configuration files and the change log, before generating a full build script containing all schema objects.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers