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

Archives: May 2017

Database Fundamentals

One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to forget about the fundamentals. More importantly, in our pursuit of the latest and greatest things, it’s very easy for those of us who teach to forget to reach back and… Read more

7 comments, 2,150 reads

Posted in The Scary DBA on 31 May 2017

SQL Crossword

I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know

4. Traditional form of an index.
6. Encrypt a column without revealing the encryption keys to the Database Engine.
8. Feature used to limit the amount of CPU,… Read more

7 comments, 2,088 reads

Posted in SQLStudies on 31 May 2017

Deleting a Package from the SSIS Catalog

Among the new features of SSIS 2016, one of my favorite is incremental package deployment. This new functionality allows the deployment of a single package to an SSIS catalog without having to deploy the entire project. Since the release of this version, I’ve been asked the following question a few… Read more

0 comments, 204 reads

Posted in Tim Mitchell on 31 May 2017

Statistics Parser

In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.

If you’ve started using these, you may notice that once you start to troubleshoot longer scripts or stored procedures that reference lots of tables or have multiple queries, you start getting… Read more

0 comments, 986 reads

Posted in Matthew McGiffen DBA on 31 May 2017

Parsing Docker Commands

Bit of a powershell themed post this week as I haven’t had that much time to research so this one falls firmly into the “what I’ve been doing this week” category.

My company moved to using containers a while ago now, it’s been really fun setting up and I’ve written… Read more

1 comments, 684 reads

Posted in The DBA Who Came In From The Cold on 31 May 2017

Powershell Module Improvements for SQL Server in 2017

simple setup

A major improvement that seems to have quietly slipped into the sql developers world is an improved SQLServer powershell module. The improved module is finally available in the powershell gallery, allowing a super quick setup on a server. No more installing SSMS to get them!

This is very… Read more

0 comments, 1,334 reads

Posted in SQL Barbarian on 31 May 2017

Implementing Fuzzy Sets in SQL Server, Part 10.2: Measuring Uncertainty in Evidence Theory

By Steve Bolton                                                                                                                      

…………To avoid overloading readers with too many concepts at once, I split my discussion of Dempster-Shafer Evidence Theory into two parts, with the bulk of the data modeling aspects and theory occurring in the last article. This time around, I’ll cover how fuzzy measures can be… Read more

0 comments, 226 reads

Posted in Multidimensional Mayhem on 31 May 2017

Log File Space Issue Monitoring Using SQL Server DMV

As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log file space related issue. Below are the previous blogs which you may find useful in your everyday job.

Read more

0 comments, 1,348 reads

Posted in SQL Geek on 31 May 2017

Making Phone Calls from Azure Event Hub Messages

Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing Streaming Data Pipelines Using Azure Data Services and as such wanted to build a compelling Azure demo that worked with simple streaming data which under certain event conditions would trigger an outbound phone call.

If… Read more

1 comments, 227 reads

Posted in Mr. Fox SQL on 30 May 2017

Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)

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

One of the most important and recurring topics for any type of indices is their Building/Rebuilding/Reorganzing processes – after all we do load more data into our tables and we want all of the bits… Read more

0 comments, 345 reads

Posted in Niko's blog on 30 May 2017

Setting up Cross Database Queries in Azure SQL Database

A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL Database. So rather than answering those questions repeatedly I figured I should blog my response up so from here on out I can just forward the link to this blog… Read more

3 comments, 1,084 reads

Posted in SQL with Dustin Ryan on 30 May 2017

Power BI Custom Visuals Class (Module 53 – Play Axis)

In this module you will learn how to use the Play Axis Power BI Custom Visual.  The Play Axis visual works like a dynamic slicer that animates your other report visuals without needing to click every time you want to change your filter value.

Module 53 – Play Axis


Read more

5 comments, 867 reads

Posted in Devin Knight on 30 May 2017

SQL Server on Linux Series: Operating System Differences

SQL Server administration, once installed and running, doesn’t vary too much based on your operating system, but the differences in the operating systems are pretty significant. To properly administer a production SQL Server on Linux, an administrator needs to understand the core basics of the Linux operating system.

I’m going… Read more

1 comments, 384 reads

Posted in Technobabble by Klee from @kleegeek on 30 May 2017

Ola Hallengren: Output File

I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to manage backups, index maintenance and the overall health of your SQL Servers. It is utilized around the globe and it is completely free.

Although his script is very… Read more

0 comments, 2,032 reads

Posted in John Morehouse | Sqlrus.com on 30 May 2017

Understanding Keys and Certificates with Always Encrypted

Always Encrypted on SQL 2016 is pretty easy to set up. There’s even a single wizard to guide you through the whole process. However, the best way to get into trouble with this technology is by not clearly understanding what is going on.

I personally find I understand things best… Read more

2 comments, 1,451 reads

Posted in Matthew McGiffen DBA on 30 May 2017

SQLSaturday Pensacola 2017

It's the start of a SQLSat summer for me, with Pensacola this weekend on Saturday June 3, then Houston two weeks later, then the rampup to my hometown SQLSaturday Baton Rouge on July 29. Hopefully everyone in the region can make it out to all three Gulf Coast region…

Read more

0 comments, 132 reads

Posted in SQL Tact on 30 May 2017

Decrease Stored Proc Execution Time By Limiting the Table Size

Hi Guys,

Hope everyone is doing well. Last week, I was working on the most exciting task on which any database developer would love to work - Performance Tuning of a Stored Procedure.

Let me explain about the code that this stored procedure consisted of. The basic task was…

Read more

0 comments, 164 reads


Angular 2 FAQs

1. What is angular module?

NgModule helps to organize an application into organized blocks of functionality. @NgModule decorator takes metadata that tells angular how to compile and run the module code. A typical NgModule looks like.

Each application in angular 2 must have at least one NgModule that you need…

Read more

0 comments, 173 reads

Posted in Querying Microsoft SQL Server on 30 May 2017

Upgrading to Modern SQL Server eBook with ScaleArc

Recently I contributed my thoughts in a new ebook from ScaleArc called “Industry Perspectives: Upgrading to Modern SQL“. Modernizing the datacenter is an ongoing struggle for those of us in the operational trenches, and a number of us in the industry contributed our thoughts to ScaleArc to help… Read more

0 comments, 164 reads

Posted in Technobabble by Klee from @kleegeek on 29 May 2017

Quitting VIM

I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM. It’s a funny post, but one that has some truth in it. I’ve gotten into VIM, almost always from git, but sometimes in Linux, and I often Google the… Read more

2 comments, 306 reads

Posted in The Voice of the DBA on 29 May 2017

Older posts