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

Latest Blog Posts

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

5 comments, 90 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, 84 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, 46 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, 47 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

0 comments, 69 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, 48 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

0 comments, 43 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, 45 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, 45 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, 65 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, 62 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, 67 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, 81 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, 104 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, 90 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:

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

Read more

0 comments, 83 reads

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

Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues.

Despite that, Extended Events takes advantage of XML much like we have seen in… Read more

0 comments, 62 reads

Posted in SQL RNNR on 26 August 2015

The 30 minute rule

In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. Kind of catchy right? But what did it mean? Simply said, if you have made no progress on a problem for 30 minutes go find some help.

The idea… Read more

2 comments, 80 reads

Posted in SQLStudies on 26 August 2015

Speaking at SQLSaturday Oslo

This weekend, I’ll hop on a plane and fly over to Norway for SQLSaturday Oslo.

I’ll be delivering a session I like a lot: The Data Loading Performance Presentation.

Among other topics, we will talk about the #1 enemy of high performance data loading, Minimal Logging and Bulk… Read more

0 comments, 104 reads

Posted in Matan Yungman on 26 August 2015

Taking #PowerPivot to the Next Level

Power Pivot is an amazing, flexible and powerful business intelligence and there is no doubt about that fact. As a feature included with Excel 2013 and 2016 (and an add-on for Excel 2010), Power Pivot allows user with a little technical expertise to integrate disparate data source together within a… Read more

0 comments, 112 reads

Posted in SQL with Dustin Ryan on 26 August 2015

Older posts