Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

SQL Saturday 496 Exeter – PreCon Agenda

Hi

Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like to thank the team though for selecting my pre-con.  Let me know if you would have liked to attend and if a viable option, I would be more than happy… Read more

0 comments, 44 reads

Posted in Dave Ballantynes blog on 14 February 2016

PASS Summit 2016 Program Committee

As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit.  I have been on the program Committee the last 4 years and 5 of the last 6.  I was shocked when I got an email saying I wasn't selected, but I'm…

Read more

0 comments, 78 reads

Posted in Wise Man or Wise Guy on 13 February 2016

Goodness-of-Fit Testing with SQL Server Part 5: The Chi-Squared Test

By Steve Bolton

…………As I’ve cautioned before, I’m writing this series of amateur self-tutorials in order to learn how to use SQL Server to perform goodness-of-fit testing on probability distributions and regression lines, not because I already know the topic well. Along the way, one of the things I’ve… Read more

0 comments, 102 reads

Posted in Multidimensional Mayhem on 13 February 2016

Speaker of the Month: February 2016

I’ve been a little remiss on this. I just haven’t been getting out to see people speak for a while (no travel is nice). However, I’m back in the airplane seats again, so these blog posts are off and running again.

Speaker of the Month for February 2016 is Jason… Read more

0 comments, 109 reads

Posted in The Scary DBA on 12 February 2016

Reblog: SSIS Performance Testing

I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in a blog post.

First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package… Read more

0 comments, 90 reads

Posted in Koen Verbeeck on 12 February 2016

Limitation of In-Memory OLTP in SQL Server 2016 – Merge not supported with memory tables as target

Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables as a Target in …

Continue reading Read more

0 comments, 147 reads

Posted in Kapil Blogs on 12 February 2016

Limiting Database Permissions for DLM Dashboard

I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues, and we weren’t sure what was wrong. As a result, I decided to dig in a bit and see how limited I could be with permissions for the login/user that… Read more

0 comments, 141 reads

Posted in The Voice of the DBA on 11 February 2016

Text Mining Loch Ness Monster Sightings

Text Mining with RapidMiner for Loch Ness Monster Sightings

Text mining involves pulling root words from text in a system.  In this example, I pulled all of the Loch Ness Monster sightings from 2000 to 2015 from the Official Loch Ness Monster Website into an Excel spreadsheet.  Then using the… Read more

0 comments, 115 reads

Posted in Business Intelligence and Enterprise Architecture on 11 February 2016

DocumentDB Tutorial 2 – Working with Documents

Join Eitan Blumin in the next video of his DocumentDB Tutorials.
This time learn how to work with the documents themselves.

If you still haven’t, be sure to first check out Eitan’s earlier posts in the DocumentDB series:

1.      Introduction to Azure DocumentDB

2.      My First Azure DocumentDB Account

3.… Read more

1 comments, 112 reads

Posted in Eitan Blumin on 11 February 2016

Moving to Open Live Writer

I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well enough and I’ve liked having an offline editor. It moved to open source after years of stagnating (though it still worked well enough!) and I’ve finally moved to that version Read more

0 comments, 151 reads

Posted in SQLAndy on 11 February 2016

SQL Server Security Principals Lightning Round Presentation

Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!

I presented a lightning round to the combined user groups on SQL Server Security Principals, which was a shortened version of a presentation I've given several times in the past. For this…

Read more

0 comments, 89 reads

Posted in SQL Tact on 10 February 2016

Azure SQL Database monitoring

Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing and monitoring the databases are limited compared to on-prem databases.  In fact, the options available are very similar to on-prem, including 3rd-party products that support Azure SQL databases.… Read more

0 comments, 167 reads

Posted in James Serra's Blog on 10 February 2016

CROSS APPLY v InLine Functions

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no good way to do this without brute force. The problem… Read more

0 comments, 147 reads

Posted in The Voice of the DBA on 10 February 2016

How Bad Are Your Indexes?

In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had different columns in SQL Server 2005 compared to 2008+, and I showed a version check I had built into the script to handle it.

It made me think…

Read more

0 comments, 97 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 February 2016

Leadership and the Data Professional

 

Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in this blog post are ones that have helped me on my journey not just in a leadership role, but from a data professional perspective as well.

I debated often… Read more

0 comments, 107 reads

Posted in The SQL Professor on 10 February 2016

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts. Because of that I’m not going to talk about the correct methods of dealing with a transaction log full error. What I want to discuss is why… Read more

3 comments, 110 reads

Posted in SQLStudies on 10 February 2016

View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!

Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power BI and time calculations! There were a bit of audio issues on my end but thankfully we were able to still have a great event with lots of great questions! Read more

0 comments, 154 reads

Posted in SQL with Dustin Ryan on 9 February 2016

VMware vExpert 2016 Announcement

What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m honored to say that I have been recognized as a vExpert for the third year running.
I also want to announce that more folks than ever…

Read more

0 comments, 160 reads

Posted in Technobabble by Klee from @kleegeek on 9 February 2016

and other pointless query rewrites

In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to a Column > 2 or Column < 2 combination, it can use indexes better.”

Sounds like something that clearly needs testing!

I’ll start with simple numbers table.

CREATE TABLE…

Read more

0 comments, 185 reads

Posted in SQL In The Wild on 9 February 2016

How Much Hospitals Charge For The Same Type Of Cases?

How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)?

The data used in this analysis may be old but it does give us a hint of how much more or less hospitals are charging… Read more

1 comments, 160 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 February 2016

Older posts