-->
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,386 reads

Posted in The Scary DBA on 31 May 2017

How to write an INSERT query

My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query. This week, we will discover some of the myriad ways to put data into a table. The good news is the concept is straightforward: we have a list of columns… Read more

0 comments, 59 reads

Posted in Born SQL with Randolph West 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

Across
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,387 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, 317 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, 1,196 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, 819 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,569 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, 343 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,777 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, 374 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

3 comments, 447 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

9 comments, 1,271 reads

Posted in SQL with Dustin Ryan 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

10 comments, 78 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

Downloads

Read more

5 comments, 1,129 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, 551 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

2 comments, 2,293 reads

Posted in John Morehouse | Sqlrus.com 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

2 comments, 50 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, 2,173 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, 233 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, 310 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 30 May 2017

Older posts