I had the recent good fortune to undertake a speaking tour in which I talked to eight chapters of the Professional Association for SQL Server (PASS) throughout the American Midwest and South. (You can ...

SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. Last week Microsoft released the preview of SQL Server 2016 ...

SQL Server tools are used across industries to improve the performance, security, and automation of databases. Modern tools ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data. In May 1974, Donald Chamberlin and Raymond Boyce published a paper on ...

I have a table that logs a record containing a userid, a fileid and a date, one record inserted every time that file is downloaded.<BR><BR>I want to get the top 10 downloads by count for a given date ...