After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.
2015-05-05
7,291 reads
Learn how you can dynamically name a file in SSIS and then send it using the FTP task.
2015-05-04
9,236 reads
There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?
2015-05-04
9,575 reads
SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.
2015-05-01 (first published: 2012-01-19)
31,420 reads
Redgate is offering a 1-day public workshop for anyone who’s interested in automated deployments for SQL Server databases. In the hands-on exercises, you’ll learn how to deploy with PowerShell and Octopus Deploy, work with NuGet packages, handle unexpected changes in your production database (database drift), test your changes with dry run releases, add review and rollback steps, check your deployments have worked, and how to fix things if your deployment fails. Find a workshop near you.
2015-05-01
6,632 reads
The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.
2015-05-01
9,908 reads
After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.
2015-04-30
6,976 reads
Are microservices the cure for the ague of monolithic applications, or do they bring their own problems with them that monolithic architectures have circumvented? Are they capable of delivering applications that are easier to maintain and develop? How can they avoid the failings of service-oriented architectures? Once more, Robert Sheldon gets to the heart of the technical issues.
2015-04-30
7,853 reads
2015-04-29
558 reads
Join Redgate on May 20th for a 1-day public workshop in London. This event is for anyone who’s interested in automated deployments for SQL Server databases. You'll learn how to: Deploy databases using Redgate's DLM tools; Assess the different requirements of production and non-production deployments, and; Handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.
2015-04-29
5,744 reads
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Make your moments memorable with Fildena 200mg, a high-strength option designed to support men...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers