Editorials

Beware the Complacency of “It just works”
September 20, 2018
For awhile now, things have been getting very stable, very reliable and the workloads of managing data are even beginning to split. Some of the [...]
Cloud Services a Commodity?
September 13, 2018
We have a number of services that are hosted with cloud providers – from this site’s hosting to our virtual event platform and others, [...]
Interesting: Data Bread Lines
July 11, 2018
In reading through a post about a book that’s out about managing and living with data, there were some very interesting observations [...]

SQL Server

Beware the Complacency of “It just works”
September 20, 2018
For awhile now, things have been getting very stable, very reliable and the workloads of managing data are even beginning to split. Some of the [...]
Tips for using indexes in SQL Server 2017 (Part 2)
September 19, 2018
Tips for using indexes in SQL Server 2017 (Part 2) If you create a composite (multi-column) index, try to order the columns in the key so that the [...]
Database and Hashing Technique – Part 4
September 17, 2018
Advantages of Database Management System (DBMS) Utilizing a Database Management System (DBMS) to manage data has numerous points of interest: [...]

From the Community

Speed Up Entity Framework Queries
September 20, 2018
(Srinath M S) Queries like the one below will perform more slowly than they could be run on a varchar [...]
Serilog Tutorial for .NET Logging: 16 Best Practices and Tips
September 20, 2018
(Matt Watson) Serilog is a newer logging framework for .NET. It was built with structured logging in mind. It makes it easy to record custom object [...]
Get and Set Volume with JavaScript
September 20, 2018
(David Walsh) The and tags provide a wealth more functionality than most people know. For instance, did you know that you could detect supported [...]
How flexible is your DB2 support team?
September 20, 2018
Flexibility is the name of the game when it comes to DB2 support. If a problem is going to happen you can bet your lunch money on it happening in the [...]
Practical SQL: PREPARE, EXECUTE, and EXECUTE IMMEDIATE
September 20, 2018
(Joe Pluta) I’ve used various features of SQL for a long time, but the one that has always given me a little trouble is the PREPARE [...]
SQL SERVER – T-SQL Script: How to Search for Multiple Values in ERRORLOG?
September 20, 2018
(Pinal Dave) There are many situations where we need to apply filters in ERRORLOG to look at meaningful data. In this blog, we would learn how to [...]
Designing a Database: 7 Things You Don’t Want To Do
September 20, 2018
(Thomas LaRock) Your database design is [...]
Azure SQL Database high availability
September 20, 2018
(James Serra) In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem [...]
SQL Reserved vCores
September 20, 2018
(blobeater) Have you ever heard of SQL Reserved vCores? Well I never until [...]
Database Maintenance and ColumnStore Indexes
September 19, 2018
(Denny Cherry) Recently on Twitter I saw a question about what index maintenance you should be doing on your ColumnStore Indexes when it comes to [...]
ASP.NET Core 2.1: Razor UI as Class Library
September 19, 2018
One of the new features of ASP.NET Core 2.1 is, Razor UI as a class library. It makes easier to build and include Razor based UI in a library and [...]

Other News

Amazon AWS Azure Editorials SQL Server

Beware the Complacency of “It just works”

by Stephen Wynkoop

For awhile now, things have been getting very stable, very reliable and the workloads of managing data are even beginning to split. Some of the management is being done by outside folks, some by automated processes and, overall, things run extremely well. It’s led to a bit of a strange trend in systems we’ve been reviewing. “Strange” because it seems […]

Continue Reading →

Community

Serilog Tutorial for .NET Logging: 16 Best Practices and Tips

by SSWUG Research

(Matt Watson) Serilog is a newer logging framework for .NET. It was built with structured logging in mind. It makes it easy to record custom object properties and even output your logs to JSON.

Continue Reading →

Community

How flexible is your DB2 support team?

by SSWUG Research

Flexibility is the name of the game when it comes to DB2 support. If a problem is going to happen you can bet your lunch money on it happening in the middle of the night on a Sunday when your most experienced DB2 DBA is on holiday.

Continue Reading →

Community

Speed Up Entity Framework Queries

by SSWUG Research

(Srinath M S) Queries like the one below will perform more slowly than they could be run on a varchar column.

Continue Reading →

Community

SQL SERVER – T-SQL Script: How to Search for Multiple Values in ERRORLOG?

by SSWUG Research

(Pinal Dave) There are many situations where we need to apply filters in ERRORLOG to look at meaningful data. In this blog, we would learn how to search for multiple values in the SQL Server ERRORLOG file.

Continue Reading →

Community

Practical SQL: PREPARE, EXECUTE, and EXECUTE IMMEDIATE

by SSWUG Research

(Joe Pluta) I’ve used various features of SQL for a long time, but the one that has always given me a little trouble is the PREPARE statement.

Continue Reading →

Community

Get and Set Volume with JavaScript

by SSWUG Research

(David Walsh) The and tags provide a wealth more functionality than most people know. For instance, did you know that you could detect supported video formats and audio formats using a few JavaScript tricks?

Continue Reading →

Community

Azure SQL Database high availability

by SSWUG Research

(James Serra) In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL Database is how much easier it is to have high availability – no need for creating and managing a SQL Server failover cluster

Continue Reading →

Community