This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your database code more robust to change.
2017-09-07
5,842 reads
Erik Darling explains why your queries aren't scaling in production.
2017-09-06
5,344 reads
In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.
2017-09-05
2,596 reads
Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family.
2017-09-05
3,084 reads
One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.
2017-09-04 (first published: 2016-10-18)
9,968 reads
In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production...
2017-09-04
4,570 reads
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
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,529 reads
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
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
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello Everyone! My organization is looking to implement a solution in SQL Server (2019...
Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers