(Rick Strahl) A few weeks ago I posted about how to set up a class library project to target multiple .NET platforms in a single project. Essentially you can specify multiple targets directly in the project.json file and then use KPM Pack (or Visual Studio) to build a Nuget package for all the diffe
Other News
Collation Conflicts
(dbafromthecold) I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to the fact that the collation of the database where the queries were running was different to the tempdb collation.
SQL SERVER – How to Increase Number of Errorlog Files
(Pinal Dave) A long back I had written a blog on – SQL SERVER – Recycle Error Log – Create New Log file without Server Restart. Recently one of my blog reader emailed me with this question:
SQL Server Video on Database Growth
(Tim Smith) Monitoring database growth and anticipating future growth is a key component for being a proactive DBA. In this video, we look at how to use PowerShell to capture SQL Server database size statistics and using this data over time to predict the growth of our databases.
Managing Complex Web Requests
(Peter Vogel) A complex ASP.NET MVC form can drive you to a big, ugly action method that handles all the functionality the page offers. The ActionMethodSelector provides a clean way to separate that logic over multiple methods, provided you understand a key distinction of which many ASP.NET MVC deve
Windows Store Apps: The Publisher attribute of the identity element in the app manifest must have . . .
(Ged Mead) I wrote a description here some time ago that covers the scary error message you can sometimes get. I had reason to go back and read this today to remind myself of the steps because I was once again experiencing the same error. Although following the steps fixed the Certificate error i
When Reporting Is Not An Option
You don’t have a data warehouse. Maybe you have a reporting database with some de-normalized data marts. Or, at best you have a reporting database populated from transactions on your OLAP database. Now you have need to produce a report most easily calculated in a data warehouse using statistical queries rather than standard SQL. Where do you begin? What options […]
SSWUGtv: Security edition: Azure Key Vault
Video Programming for IT Professionals
Gearing up your Business for data analytics – Part VI
Gearing up Your Business for Data Analytics – Part VI Having cleared our minds of possible confusions with regard to single view of customer and single view of data in the previous article in this series, let us move on to the study of data quality problems. For instance, if the customer data contains an email id, the same must...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Making HAProxy 1.5 replication lag aware in MySQL
(Stephane Combaudon) HAProxy is frequently used as a software load balancer in the MySQL world. Peter Boros, in a past post, explained how to set it up with Percona XtraDB Cluster (PXC) so that it only sends queries to available nodes. The same approach can be used in a regular master-slaves setup t