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

Archives: July 2017

Streaming Reporting: SQL Change Data Capture (CDC) to Power BI

Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I have had a few people ask for details/options to stream SQL data into the Power BI API.

Specifically – they were looking for an easy method to leverage the ADD ROWS functionality of… Read more

1 comments, 391 reads

Posted in Mr. Fox SQL on 31 July 2017

Automating tSQLt Unit Tests

This is the ninth part in the series: SQL Server and Continuous Integration. In this post I’ll add some unit tests and pull them into the build process in GitLab. Topics covered so far in this series are:

Read more

1 comments, 226 reads

Posted in The Database Avenger on 31 July 2017

Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)

In this module you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single metric across a month calendar.

Module 62 – Beyondsoft Calendar

Downloads

Read more

1 comments, 930 reads

Posted in Devin Knight on 31 July 2017

Start Your Engine’s with Startup Procedures

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up procedures.  This caught my attention as I was not fully aware of what those were.  Naturally I decided to investigate further.

Startup procedures automatically execute whenever SQL Server is… Read more

7 comments, 1,335 reads

Posted in John Morehouse | Sqlrus.com on 31 July 2017

Start Your Engine’s with Startup Procedures

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up procedures.  This caught my attention as I was not fully aware of what those were.  Naturally I decided to investigate further.

Startup procedures automatically execute whenever SQL Server is… Read more

7 comments, 13 reads

Posted in John Morehouse | Sqlrus.com on 31 July 2017

Need to output CSV, TSV, or other?

Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017 we get a new native function to do exactly that. Specify a delimiter and you get a delimited list.

SQL 2016 brought us a native function for parsing a CSV… Read more

1 comments, 54 reads

Posted in Confessions of a Microsoft Addict on 31 July 2017

Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge

Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern applications. Steve and I are the principal consultants for appdev and SQL Server respectively at Sparkhound, and figured that a joint presentation on this topic would be valuable.

It was!…

Read more

0 comments, 233 reads

Posted in SQL Tact on 31 July 2017

Backup Log to Nul– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it.

There are times when you might be working on your demo/lab system… Read more

4 comments, 1,170 reads

Posted in The Voice of the DBA on 31 July 2017

Being a Positive Influencer

I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to arrive at a better, more productive, more useful individual. I suck at it.

Positive

If you read a lot of these books and articles about how to go about getting… Read more

2 comments, 19 reads

Posted in The Scary DBA on 31 July 2017

Being a Positive Influencer

I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to arrive at a better, more productive, more useful individual. I suck at it.

Positive

If you read a lot of these books and articles about how to go about getting… Read more

2 comments, 1,392 reads

Posted in The Scary DBA on 31 July 2017

Learning through gaming a SQL Server tale

I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience training technology and speaking but it never fails; after about 5 minutes his eyes glaze over and he nods and “umhums” and then starts checking his phone.

 

Maybe technology… Read more

3 comments, 1,646 reads

Posted in Confessions of a Microsoft Addict on 31 July 2017

DBA Dice

I’ve always thought it would be fun to have a DBA themed magic 8-ball. Now you may not be aware of this but the inside of a magic 8-ball is actually a 20 sided die. So since a custom magic 8-ball is more than this cheap geek is willing to… Read more

0 comments, 153 reads

Posted in SQLStudies on 31 July 2017

Video Tutorial: Creating a SQL Server Databases

In this Video tutorial we will look at creating a SQL Server database using both Management Studio and TSQL. We’ll also discuss some of the database options you can set when creating a database. We will look at creating database objects such as tables, indexes and stored procedures in a…

Read more

0 comments, 163 reads

Posted in The SQL DBA in the UK on 31 July 2017

Monday Coffee: The evolving DBA

Over the weekend I saw a few tweets about the role of the DBA. These tweets (and corresponding blog posts) come around once every so often and are generally along the lines of “Is the DBA role dead?” (or something to that ilk).

Here’s my two cents on the matter,… Read more

1 comments, 157 reads

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

Change RegisterAllProvidersIP setting on an existing Availability Group

Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on their cluster. So, recent changes to their connection strings to take advantage of MultiSubnetFailover to minimize failover re-connection delay wasn't helping. Multisubnet failover needs to see both Listener IP's to…

Read more

2 comments, 1,038 reads

Posted in SQL Tact on 30 July 2017

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

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

Do you remember one of the major problems in SQL Server 2014 using Columnstore Indexes ? It was the lack of the support for the Batch Execution Mode with just a single core. We would… Read more

2 comments, 1,096 reads

Posted in Niko's blog on 30 July 2017

Dynamics 365 AX – Creating Data Entities for BYOD Azure Database including those without a natural key

We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially one that is made by Microsoft. However, the live Dynamics (365) AX database cannot be assessed directly currently. The diagram above shows that the Primary AX DB is copied into…

Read more

0 comments, 269 reads

Posted in Terry's Business Intelligence on 29 July 2017

That thing you want to do? Do the thing.

You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it? Could he keep up with it? Will you end up embarrassing yourself? Let's talk.

The post That thing you want to do? Do the thing. appeared first on The MidnightDBA… Read more

0 comments, 292 reads

Posted in SQL Awesomesauce on 29 July 2017

Columnstore Indexes – part 108 (“Computed Columns”)

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

As we are approaching the RTM (release to manufacturing) of the SQL Server 2017, I decided to focus on the implemented features in the upcoming release, thinking that if they are in the RC (release candidate)… Read more

0 comments, 324 reads

Posted in Niko's blog on 29 July 2017

How to Configure TDE database with AlwaysOn using the Azure Key Vault in SQL Server 2016

One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to configure Transparent Data encryption (TDE) using asymmetric key protection with Azure Key Vault with AlwaysOn. That, to me, opened a whole different dimension on data security.

Configure-tde-database-alwayson-using-azure-key-vault-sql-server-2016

Happy Learning!! Read more

0 comments, 283 reads

Posted in PowerSQL By Prashanth Jayaram on 28 July 2017

Older posts