Design a Better SQL Server Pricing Model
Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.
Microsoft Azure DocumentDB
Microsoft's DocumentDB is a late-entrant in the Document-oriented database field. However, it benefits from being designed from the start as a cloud service with a SQL-like language. It is intended for mobile and web applications. Its JSON document-notation is compatible with the integrated JavaScript language that drives its multi-document transaction processing via stored procedures, triggers and UDFs. Robert Sheldon investigates its SQL-like query language.
Hard Data v Gut Feel
Data is more important than gut feel, or at least, Steve Jones thinks it should be more important. Today he talks about using data to support decisions.
Network Load Testing Using iPerf
Tim Radney of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue.
The DBA Tax
Are you a DBA tax on your company? Or an asset that's worth the cost. Steve Jones talks about trying to be the latter and not the former.
Time and Space: How to Monitor Drive Space in SQL Server
How to monitor drive space in T-SQL and calculate when your drives will run out of space.
Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2
Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.
Documenting Your PowerShell Binary Cmdlets
Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line or IDE, the same isn't true of binary cmdlets written in C#. At last, there is an open-source utility to assist with this that is being actively maintained and updated. At last, binary cmdlets need no longer be the poor cousins of scripted cmdlets in their documentation
Having fun with PARSENAME (SQL Spackle)
PARSENAME is perhaps the most infrequently used built-in documented function in SQL Server. SQL Server Microsoft Certified Master Wayne Sheffield shows why this nifty function ought to be included in your SQL toolbox.
Security Convenience
Security is always a hot topic, and Steve Jones notes that we should be specific when we work with security.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers