(Jeff Smith) Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data?
Author: SSWUG Research
Adding Core References Support in an ASP.NET Empty Project
(Xueyuan Dai) In Visual Studio 2013 we introduced the core reference framework to ASP.NET project creation. You can choose what core references you want in your to-be-created project.
ASP.NET N-Layered Applications – Implementing a Repository using EF Code First (Part 5)
(Imar Spaanjaars) This is Part 5 in a series of 10 that show you how to build N-Layered applications using ASP.NET 4.5 and Entity Framework 5 Code First. In this part you’ll see how to build a concrete implementation of the repository that was introduced in the preceding article.
Deserialising JSON or XML to a Map using Java
(Tom) Well, here’s a thing. Imagine you have some XML or JSON that looks like a map, only you don’t know the names or number of the properties in advance. For example:
What Virtual Filestats Do, and Do Not, Tell You About I/O Latency
(Erin Stellato) One of the first things I look at when I’m troubleshooting a performance issue is wait statistics via the sys.dm_os_wait_stats DMV. To see what SQL Server is waiting on, I use the query from Glenn Berry’s current set of SQL Server Diagnostic Queries. Depending on the output, I start
Columnstore Insert and Update Performance
(Joey D’Antoni) I had been holding off on writing this blog post with SQL 2014 CTP1, since updateable columnstores were definite a work in progress. I did get several questions about the updatable columnstores during my presentation at the recent SQL PASS summit. So with a fresh VM with SQL 2014 CTP
Using Bind Variables on SQL Server or Oracle
(Peter Tran) I often have to analyze SQLs that uses bind variables to determine the execution plan used by the database engine. When given the actual literal SQLs, the optimizer engine has more information and may use a different (sometime more optimal) execution plan.
Manage SQL Server Reporting Services in Management Studio
(Scott Murray) I hear I can manage SQL Server Reporting Services in Management Studio? Is that true?
Tuning Distributed Applications to Access Big Data
(Lockwood Lyon) Distributed applications are just that: distributed across one or more hardware platforms across the enterprise. These environments are usually separate from that of the database server.
MySQL 5.6 – Now with fewer gripes
(morgan tocker) I often find myself in conversations with long time MySQL users who tell me about little annoyances in MySQL that make the product harder to use. Sometimes these annoyances can stay in a product for seemingly forever, because they require a change in behaviour (breaking backwards com