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

Latest Blog Posts

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, 0 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, 36 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, 8 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, 48 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, 141 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, 110 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, 62 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, 64 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

1 comments, 100 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, 58 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, 52 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, 56 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, 56 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, 74 reads

Posted in PowerSQL By Prashanth Jayaram on 26 August 2015

Uploading Files to an HDInsight Cluster (No Scripting Required)

As I noted in my first post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Now we are going to look at how to upload files without scripts. While this will work for our demo and… Read more

0 comments, 69 reads

Posted in DataOnWheels on 26 August 2015

Critical Virtualized Database Education at VMworld

If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any number of virtualized databases in your environment, you need to attend these sessions!

First and foremost, Thomas LaRock (@sqlrockstar) and I are presenting a session called “ Read more

0 comments, 73 reads

Posted in Technobabble by Klee from @kleegeek on 26 August 2015

SSC Editorial: Annual Security Compliance Training

Compliance training, never a fun topic and I think that is too bad. A combination of companies checking the box, lacking imagination, and being stuck with rules that require doing it annually. Do we really need to review the employee manual if it hasn’t changed since last time? Or… Read more

0 comments, 88 reads

Posted in SQLAndy on 26 August 2015

The Problem With AshleyMadison - WaterOx Consulting

Reading Time: 3 minutes

What is the real problem with the AshleyMadison data breach? Well, let...

The post The Problem With AshleyMadison appeared first on WaterOx Consulting.

Read more

3 comments, 115 reads

Posted in WaterOx SQL on 26 August 2015

Agile Development – A DBA’s Initial Thoughts

I recently had the opportunity to attend a three day Agile development workshop.  At a very high level, Agile development values making small, iterative changes over short periods of time, unlike traditional software development methods that generally involve a large release at the very end of a project.  If you’ve… Read more

0 comments, 101 reads

Posted in Adam Kreul | Blog on 26 August 2015

Slides and Demos for #SQLSupper August meeting

Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols including a rather fun live demo.

The slides and demo apps are available: https://github.com/GoEddie/SQLSupper-WhenMarsAttacks

If anyone wants to know more about MARS or TDS feel free to contact me as…

Read more

0 comments, 92 reads

Posted in Ed Elliott's Sql Developer Blog on 26 August 2015

Older posts