SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2017

Information Measurement with SQL Server, Part 2.1: The Uses and Abuses of Shannon’s Entropy

By Steve Bolton

…………In the first installment of this wide-ranging series of amateur tutorials, I noted that the Hartley function indeed returns “information,” but of a specific kind that could be described as “newsworthiness.” This week’s measure also quantifies how much we add to our existing knowledge from each… Read more

0 comments, 878 reads

Posted in Multidimensional Mayhem on 31 August 2017

SQL Server: SARGability

SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know. I plan to do a few blogs on this topic and today marks the first.

What is a Search Argument?

Simply put a SARG is a portion of… Read more

2 comments, 794 reads

Posted in Confessions of a Microsoft Addict on 31 August 2017

Bulk Inserting Build Data–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

One of the common tasks that many DBAs need to do is insert data into a database. Often this comes from various sources, but a CSV (comma separate… Read more

2 comments, 669 reads

Posted in The Voice of the DBA on 31 August 2017

Azure Archive Blob Storage

Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost cloud storage solution for rarely accessed data.  This allows for storage tiering, where organizations can place their critical data on expensive, high-performance storage and then move it down the line… Read more

2 comments, 999 reads

Posted in James Serra's Blog on 31 August 2017

Automatic Seeding & Compression

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Last week I have talked about the basic concepts behind Automatic Seeding in SQL Server 2016 Availability… Read more

2 comments, 554 reads

Posted in Klaus Aschenbrenner on 31 August 2017

Getting the Hyperlink from Excel

I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base Articles with a hyperlink associated with them. I would assume there’s an easy function in Excel to extract these, but apparently there isn’t. That’s certainly a useful function for a… Read more

2 comments, 666 reads

Posted in The Voice of the DBA on 30 August 2017

Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)

Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

The topic of the Segment Elimination (aka Row Group Elimination) is something that I keep on blogging on through all the years, but given that Joe Obbish has written an incredibly valuable blog post on… Read more

0 comments, 685 reads

Posted in Niko's blog on 30 August 2017

What you need to know about memory limits on SQL Server

Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max Server Memory is *not* just for the buffer pool. The RAM limit Standard Edition can use *is* just for the buffer pool. Joey D’Antoni was quick to remind me that… Read more

0 comments, 330 reads

Posted in Born SQL with Randolph West on 30 August 2017

System-Versioned Temporal Tables

Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it peeked my interest, so I figured I’d investigate and share my finding with you.

How many of you… Read more

2 comments, 1,084 reads

Posted in SQLEspresso on 30 August 2017

You might be a DBA if

I’d been trying to think of a fun post to write and an homage to Jeff Foxworth’s You might be a redneck series seemed like a good idea. To that end, I create a hashtag #YouMightBeADBA and wrote my post on twitter :). Of course, it turns out that the… Read more

5 comments, 1,862 reads

Posted in SQLStudies on 30 August 2017

SSMS and MFA support for Azure SQL DB

Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server Management Studio (SSMS) 17.2 You now have the option to use Azure AD authentication for Universal Authentication with Multi-factor authentication (MFA) enabled, by that I mean use a login via… Read more

0 comments, 641 reads

Posted in All About SQL on 30 August 2017

Speaking at SQL Saturday Spartanburg (#681)

I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg (#681) on September 23, 2017.  I will be presenting my What is Power BI? session at 8:30am.  I know it’s early, but I’d love to see you if you are… Read more

0 comments, 481 reads

Posted in SQL Swimmer on 30 August 2017

Offline Microsoft Documentation? Download it!

On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip on Microsoft Documentation!

Download Microsoft Documentation

Did you know that we can download PDF files with Microsoft Documentation?

I did not know until my colleague called my attention to… Read more

0 comments, 966 reads

Posted in Cláudio Silva on 30 August 2017

Ich werde Deutschland beriesen

Guten Tag!

OK, switching back to English for the rest of this.

I’m going to be spending a few weeks in Germany on a private tour, no work. That means that, no, I’m very sorry, I can’t speak at your user group, even though I’d love to. Next time.

However,… Read more

2 comments, 518 reads

Posted in The Scary DBA on 30 August 2017

Running SQL Server in Kubernetes on Azure Container Services

I’ve been meaning to get to grips with Kubernetes for a while now but I have to admit, I was completely overwhelmed when I first approached the subject. There’s so much information and documentation out there, it’s difficult to know where to start.

What really helped was James Anderson’s ( Read more

2 comments, 818 reads

Posted in The DBA Who Came In From The Cold on 30 August 2017

Microsoft Azure – How to create a virtual machine using PowerShell – Part 2

Hello friends, you can find the post at below link – https://social.technet.microsoft.com/wiki/contents/articles/40010.how-to-create-a-virtual-machine-in-microsoft-azure-using-powershell-part-2.aspx Tagged: Azure, Microsoft Azure, Powerhsell, Powershell, SQL Azure, Virtual Machine, Windows Powershell

Read more

0 comments, 762 reads

Posted in Kapil Blogs on 30 August 2017

The Game Night Poll

This year we’ve handed off Game Night to the PASS organization and it’s an official event. Volunteers from the community will help setup, manage, and tear down the event. Kevin Hill is taking the lead, but if you’re willing to help run the night, let he or I know.… Read more

1 comments, 625 reads

Posted in The Voice of the DBA on 29 August 2017

The 10 Basic Concepts of T-SQL

For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the basic concepts I recommend the students to remember and master in order to become proficient at writing T-SQL (and SQL in general). There’s no reason to keep those concepts inside… Read more

8 comments, 572 reads

Posted in Matan Yungman on 29 August 2017

Database Fundamentals #8: All About Data Types

SQL Server provides all different kinds of data types in order to give you more flexibility and control for how you store your data. You define these data types as you define the columns in your tables. If you wanted to store information about the date and time that a… Read more

6 comments, 619 reads

Posted in The Scary DBA on 29 August 2017

Database Fundamentals #8: All About Data Types

SQL Server provides all different kinds of data types in order to give you more flexibility and control for how you store your data. You define these data types as you define the columns in your tables. If you wanted to store information about the date and time that a… Read more

6 comments, 1,368 reads

Posted in The Scary DBA on 29 August 2017

Older posts