Robert Sheldon How to Get SQL Server Dates and Times Horribly Wrong One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time... 28 May 2015 35 min read
Dennes Torres Optimizing Batch Process in SQL Server SQL Server batch processes are usually run from SQL Agent in background. They can take significant time and resources, especially if they are ETL tasks.... 08 May 2015 32 min read
Feodor Georgiev Making Data Analytics Simpler: SQL Server and R R and SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have... 28 April 2015 13 min read
Adam Aspin Mobile BI with SQL Server Reporting Services For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics... 15 April 2015 30 min read
Richard Morris Swizec Teller : Geek of the Week Why do programmers work best at night? Is this related to the idea that drinking alcohol improves cognitive ability? Is programming a young person's game?... 09 April 2015 10 min read
Phil Factor Schema-Based Access Control for SQL Server Databases Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by... 09 April 2015 25 min read
Joshua Feierman How DBAs Can Adopt the Craftsman Mindset The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen find that the better they... 01 April 2015 16 min read
Dino Esposito Premature Scalability and the Root of All Evil When you're designing an application, there is a temptation to build it to a super-scalable future-proof architecture, even when the immediate requirements can be met... 18 March 2015 13 min read
Fabiano Amorim Never Ignore a Sort Warning in SQL Server It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning... 18 March 2015 9 min read
Robert Sheldon The Internet of Things: A New World Order? Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet... 10 March 2015 15 min read
Dino Esposito RWD, Mobile-first, JavaScript and Performance The easiest way to make a responsive web application perform well is to minimize requests and the amount of data that is downloaded. The most... 28 February 2015 11 min read
Dino Esposito Quick and Dirty Web Data-Binding Sometimes, the sheer byzantine complexity of the typical JavaScript frameworks underlying a typical web application can give you pause for thought. If all you need... 04 February 2015 12 min read
Michael K Campbell The Importance of Caching Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs - by helping keep CPU utilization low. But it's important to... 04 February 2015 15 min read
Dwain Camps Bowled Over by SQL Window Functions What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic... 26 January 2015 27 min read
Feodor Georgiev How to get ETL Horribly Wrong ETL ( Extract, transform, load) doesn't have to be like a spell on hell. To make a success of ETL systems, you need the freedom... 09 January 2015 14 min read
Kathi Kellenberger SQL Server Reporting Services Basics: Deploying Reports Having designed and tested our reports, it's time to deploy them to the Report Server, so that our users can access them. Kathi Kellenberger demonstrates... 06 January 2015 20 min read
Joshua Feierman High Availability and Disaster Recovery for Small Businesses Too often in the past , High Availability and Disaster Recovery have been marketed as expensive choices for businesses with deep pockets. The truth is... 16 December 2014 13 min read
Nick Harrison Extending Editor Templates for ASP.NET MVC If you find yourself doing routine work repeatedly in ASP.NET MVC, it is worth exploring the possibilities that come from modifying or creating Editor Templates... 02 December 2014 12 min read
Matthew Skelton Continuous Delivery for Databases: Microservices, Team Structures, and Conway’s Law Having described some of the most common database deployability blockers, Matthew Skelton proposes a way to enable database continuous delivery that isn't as outlandish as... 19 November 2014 20 min read
Phil Factor Bitwise Operations in T-SQL How can you, in T-SQL, get a list of columns that have changed within a trigger? How can you see what bits are set within... 18 November 2014 22 min read