SQLCMD and Batch File magic
Execute scripts in a folder with a single click using SQLCMD and a batch file.
2017-07-28 (first published: 2015-11-19)
22,654 reads
Articles
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.
2017-07-28
5,168 reads
Advanced Analytics with R and SQL Part II - Data Science Scenarios
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-07-27
1,625 reads
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.
2017-07-27
6,123 reads
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.
2017-07-26
5,228 reads
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.
2017-07-25
5,102 reads
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.
2017-07-25
348 reads
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.
2017-07-25
5,860 reads
The Case of the Space at the End
A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?
2017-07-24
9,127 reads
Testing DML Statements for In-Memory OLTP
Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.
2017-07-24
4,663 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers