Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Pluralsight Authoring – Upcoming Course

I am super excited to announce that I have recently been accepted as an author for Pluralsight.

My audition was on Monitoring AlwaysOn Availability Groups and was accepted on the first pass :) the clip discussed monitoring replication latency something I’ve blogged about here and here.

In the… Read more

0 comments, 52 reads

Posted in Anthony Nocentino's Blog on 29 August 2015

5 Tips for #PowerBI

After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that have helped me to be able to create some pretty cool data visualizations and dashboard reports. Here are five Power BI tips and tricks that you may find useful as… Read more

0 comments, 59 reads

Posted in SQL with Dustin Ryan on 29 August 2015

How to create first basic package with SSIS ? tip #113

Dear friends,

In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in practical session where we will try to create a basic simple package.

The example which we are creating is well known Export data from SQL SERVER… Read more

0 comments, 40 reads

Posted in Rajat Jaiswal-337252 on 29 August 2015

Row-Level Security in SQL Server and Azure

Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based on the users executing those queries: if a user isn’t authorized to access certain rows in a table then those rows are automatically filtered out by the database engine.… Read more

0 comments, 56 reads

Posted in Gorandalf's SQL Blog on 28 August 2015

SQL Saturday Baton Rouge 2015 Recap

SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee Chair's recap of the event.


Here's one of the big new things we did this year:
  • We have a large, four-building facility for our event with multiple entry points. We…

Read more

0 comments, 44 reads

Posted in SQL Tact on 28 August 2015

Using Power BI with HDInsight Part 2: Power BI Desktop and Hive

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster… Read more

0 comments, 55 reads

Posted in DataOnWheels on 28 August 2015

Sixty Days to Summit–Are You Ready?

In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a couple of months away, this is a great time to start making preparations to ensure that you get the most out of your Summit experience.

Download and install… Read more

0 comments, 49 reads

Posted in Tim Mitchell on 28 August 2015

017 – Thinking Like A Manager - WaterOx Consulting

Reading Time: 2 minutes

Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like...

The post 017 – Thinking Like A Manager appeared first on WaterOx Consulting.

Read more

0 comments, 83 reads

Posted in WaterOx SQL on 28 August 2015

Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix

Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised when I see that Explorerfunctionality was not working. Generally it is used to manage members for Entities and Hierarchies. It is one of…

Read more

0 comments, 48 reads

Posted in SQL & BI on 28 August 2015

The Fastest Way to Combine DATE and TIME Data Types to a DATETIME

Recently while working with a table where there were two columns, one a DATE datatype and a second TIME datatype, I found that those needed to be combined into a single DATETIME result column. I won’t go into why the DATE and TIME were separated in this case, but suffice… Read more

0 comments, 139 reads

Posted in DwainCSQL on 28 August 2015

I am not a “wogrammer”

So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing.  (Thanks to Vicky Harp for pointing out this infuriating thing.) I cannot stress how fundamentally opposed I am to this, new, stupidest of ideas. Why? Let’s delve into a little…

Read more

6 comments, 157 reads

Posted in SQL Awesomesauce on 27 August 2015

tSQLt in Azure SQL Database

I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I’ve been doing testing work with tSQLt and wanted to run tests in an Azure database.

I upgraded a SQL Azure database to v12 and connected in SSMS. My first step was to open the… Read more

0 comments, 135 reads

Posted in The Voice of the DBA on 27 August 2015

Using Power BI with HDInsight Part 1: Power Query and Files

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster… Read more

0 comments, 73 reads

Posted in DataOnWheels on 27 August 2015

Getting Started With Power BI Desktop: Simple Visualization

This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data. In this post, let’s see how easy it is to create visualization on Power BI Desktop. If you’re quite familiar with creating… Read more

0 comments, 84 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 27 August 2015

Relational databases vs Non-relational databases

I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared to the relational databases solutions that have been around for many years.  So let me try to explain the differences and best use cases for each.

First lets clarify these… Read more

3 comments, 131 reads

Posted in James Serra's Blog on 27 August 2015

Does SQLSaturday Increase Chapter Attendance?

One of the big goals for SQLSaturday was for it to be a membership drive. It’s worked hugely well in some ways; we’ve added tremendously to the number of PASS members, grown the size of the Chapter mailing lists (for those that held a SQLSat), and introduced a lot of… Read more

2 comments, 72 reads

Posted in SQLAndy on 27 August 2015

SQLSat403 – Recap

The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event has come and gone, but this time it was different. The reason for this was from the hard work, effort, countless hours, and collaboration that took place.

This past year… Read more

1 comments, 61 reads

Posted in The SQL Professor on 27 August 2015

Reblog: Force installation of 64-bit ACE OLE DB provider

Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime Read more

0 comments, 70 reads

Posted in Koen Verbeeck on 27 August 2015

Entity Sync Relationship - Master Data Services 2016


Entity Sync Relationship  is a new feature in Master Data Services 2016. It enables you to share entity data between different models. You can keep a single version of truth in one model and reuse it in an another model.

I was wondering where should I use it? Do…

Read more

0 comments, 66 reads

Posted in SQL & BI on 27 August 2015

Use FILEPROPERTY to find free space in all the database

The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot of other attributes of it such as free space and percentage of free space.

For other versions of SQL you can refer the below SQL.

DECLARE @command VARCHAR(5000)…

Read more

0 comments, 82 reads

Posted in PowerSQL By Prashanth Jayaram on 26 August 2015

Older posts