Statistics in SQL: The Mann–Whitney U test
Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution.
2017-09-04
4,456 reads
Articles
PowerShell Tool Time: Our First Toolbox
Learn how to begin assembling your functions and code into modules you can easily call from any session.
2017-09-01 (first published: 2015-10-28)
7,549 reads
What is the biggest mistake you made in production?
When you have sysadmin access, you are bound to make a big mistake in production at some point in your career - in this post Tara Kizer looks back at what hers were.
2017-09-01
4,773 reads
Resolving could not open a connection to SQL Server errors
Have you ever gotten connectivity errors from SQL Server? Jugal Shah explains the common causes for these errors, and advises on the steps you can take to resolve them.
2017-08-31
3,542 reads
Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment
Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.
2017-08-30
2,895 reads
Fighting Evil in Your Code: Comments on Comments
One of the most glib generalisations you can make about development work is to say that code should be liberally commented, or conversely that it should never be commented. As always, the truth is more complicated. There are many different types of comment and some types are best treated firmly with the delete key, where others are to be cherished and maintained assiduously. Even though it is hard to find two developers who agree on the topic of commenting, Michael Sorens warily sketches out the issues and the battleground.
2017-08-29
3,670 reads
TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources
TDS remoting services provide a native SQL experience with local and remote ODBC data sources (contrast with limitations of using OLE DB).
2017-08-28
3,651 reads
Implementing Azure SQL Data Sync in the Azure Portal
Azure SQL Data Sync, which has been lingering in the Preview mode since its introduction seven years ago, no longer requires the use of the Azure classic portal; you can finally access it by using the current Azure portal. Marcin Policht steps you through the process of implementing Azure SQL Data Sync using this interface.
2017-08-28
2,868 reads
SQLCMD Mode; Run all SQL files in a directory
SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.
2017-08-25 (first published: 2015-09-14)
25,682 reads
Why PolyBase Matters
An alternative approach to disaster recovery and backup strategies using PolyBase.
2017-08-25 (first published: 2015-08-10)
7,257 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