Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions? Kathi revisits a famous SQL challenge to find out.
2015-09-18
4,213 reads
Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.
2015-09-17
4,230 reads
If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica - but there are multiple ways to do this. Jonathan Kehayias goes through each, explaining their different benefits and drawbacks.
2015-09-17
2,771 reads
Marcin Policht gives an overview of automated management features based on the SQL Server IaaS Agent Azure VM extension.
2015-09-16
5,861 reads
Read a call to get started using Version Control with your database code with a few ideas on how this can help you.
2015-09-15
6,203 reads
If you don't feel that you are getting helpful and comprehensive feedback from code reviews, it may well be your fault. Unless you are considerate to your reviewers in a number of ways, they might find it difficult to check your code and provide helpful advice. What ways? Michael Sorens outlines the eight golden rules that, if you follow them, might even even make your code a pleasure to review!
2015-09-15
6,927 reads
2015-09-14
2,399 reads
Jeffrey Yao suggests a solution to validate Excel data via PowerShell and Regular Expressions.
2015-09-14
3,457 reads
If you are planning on taking the Microsoft Certification Exam for 70-462, this guide provides the step-by-step instructions to completely setup your Hyper-V lab environment used in the official training kit.
2015-09-11 (first published: 2013-11-25)
19,198 reads
Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.
2015-09-11
3,709 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers