Life Lessons – Are There Rules for Interacting With Customers?
I personally don’t claim to know everything and most of my soft skills, learning / techniques has got seasoned over the years. It is something I try to emulate, learn and get guidance from 100’s of people I meet daily. I vividly remember ta …
Hotfix Released for July 2016 SQL Server Management Studio Download
The Microsoft Data Platform MVPs and SQL Server Product Group at Microsoft have worked hard to identify and resolve issues from the July 2016 release of SQL Server Management Studio. The hotfix with these changes has just been released. read more
Why Not Just Create Statistics?
Here at Brent Ozar Unlimited We have a proud tradition of not blaming index fragmentation for everything. There are points you should deal with it, but they’re probably not 5% and 30% and 1000 pages. But that’s not what this blog post is ab …
HPE Superdome X and SQL Server In-Memory OLTP Powers Online Financial Services
It’s one thing to quote performance numbers and availability measures, and quite another to see how these statistics translate into real-world implementations. read more
Stairway to DLM Dashboard Level 2: Setting up DLM Dashboard
Learn how to install and configure your initial DLM Dashboard instance.
Introduction to Row Level Security in SQL 2016
In SQL 2016 several new security features gets introduced which will help users to protect their data in many ways. New security feature Row Level Security (RLS) which implements the security inside the database itself, not at application level. How to …
SQL SERVER 2016 – Encrypt Your PII Data – Notes from the Field #132
[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell talks about his thoughts and observation about SQL Server 2016 Encryption. Security of the data is very important and we often spend so man …
Can Adding an Index Make SQL Server 2016…Worse?
Using the StackOverflow database, let’s check out Krock’s query. He’s a competitive fella, and he’s looking to find users who signed up for StackOverflow after he did, but who have a higher reputation than he does. I’ …
Enterprise Database Monitoring Tools for SQL Server and the HPE Superdome X Platform
Ongoing database monitoring and management is one of the most important jobs that the enterprise database professional has. Ongoing monitoring is essential to keeping your SQL Server system—and the systems working with it–operating efficiently. …
Different Options for Importing Data into SQL Server
Moving data into SQL Server is something that most DBAs or Developers are faced with probably on a daily basis. In this article, Greg Robidoux explores the various options for doing so.
Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories
Learn how to get started working with SMO and PowerShell.
SQL SERVER 2016 – Find Expiry Date of Developer Edition
The title of the blog is little weird, but it was a question asked to me by a developer. Have you ever got such error messages which are strange yet difficult to comprehend? He told me that he has installed SQL Server 2016 developer edition from MSDN ( …
Geek City: My SQL Server 2016 RTM In-memory OLTP Whitepaper
Finally, we have a download available. You can go to this page microsoft.com/en/server-cloud/products/sql-server/ and scroll down to the section ‘Technical Resources’. (NOT the section on the left called White papers). Click on “SQL Server 2016 I …
New Course: Statistics – SQL Server’s Guessing Game
Closed captioned for your statistical pleasure You have to make queries go faster, and you suspect that outdated or inaccurate statistics are hurting your execution plans. Doug Lane is here to help with his new $29 video course, Statistics: SQL Se …
What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 2
SQL Server 2016 introduces the batch mode Window Aggregate operator, which dramatically improves the performance of calculating window functions. Besides the general performance advantages of batch mode processing compared to row mode processing, this …