Getting Started with SQL Server 2012 Express LocalDB
Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.
Advanced Analytics with R and SQL Part II - Data Science Scenarios
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
Statistics in SQL: The Kruskal–Wallis Test
Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis test is a safe way of determining whether samples come from the same population, because it is simple and doesn't rely on a normal distribution in the population. This allows you a measure of confidence that your results are 'significant'. Phil Factor explains how to do it.
SQL Crossword #1
Today we start a new puzzle series, with a crossword puzzle from MVP Kenneth Fisher.
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
Azure DWH part 12: Permissions, roles, logins and users
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
Containers for enhanced Data Governance and Compliance
Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.
The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects
Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.
The Case of the Space at the End
A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers