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

Latest Blog Posts

The PASS Speaker Agreement

I hope when you’ve read all of this post that you’ll think that I’ve added to the discussion and not fueled the fire.

The various posts and discussions and the time writing this (multiple drafts) have definitely caused me to re-examine my own views. I’ve found that some were simplistic… Read more

2 comments, 780 reads

Posted in SQLAndy on 20 June 2016

Using Power BI with Enterprise, On-premises Data

I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data.  The running time for all four parts is about 44 minutes.  I cover using the Power BI Enterprise Gateway to connect published Power BI reports to on-premises data sources:  SQL Server database connected with…

Read more

2 comments, 196 reads

Posted in SQL Server BI Blog on 19 June 2016

Power BI Architecture Diagram v2 is Now Available

I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram but as fast as Power BI is changing, v1 of the diagram was quickly obsolete. I always wanted to come back and add more to the diagram to make it… Read more

6 comments, 267 reads

Posted in SQL with Dustin Ryan on 18 June 2016

The RGE

I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores, and I like it. However I realize that I’ve never actually noted what it is, so a short blog to do so today.

An RGE is a… Read more

5 comments, 1,256 reads

Posted in The Voice of the DBA on 17 June 2016

Return Max or Min Value of a Group of Columns as a Single Column

Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never used again (turns out, there’s quite a lot of them in this database). They are characterized by having _bak or _ appended to the end of them. I wanted to…

Read more

Upcoming Course – LFCE: Advanced Linux Networking

I’m pleased to announce that I’m working on a new course for Pluralsight.

The course is titled LFCE: Advanced Linux Networking.

This course targets IT professionals that design and maintain Linux based enterprises. It aligns with the Linux Foundation Certified Engineer (LFCE) objectives and can be used by… Read more

0 comments, 133 reads

Posted in Anthony Nocentino's Blog on 17 June 2016

Why is creating excel sheets from SSIS so hard ?

If there is one process that should be simpler than it is out of the box, it is creating Excel spreadsheets from SSIS.   Over the years i’ve tried doing it a number of ways, using the built in component,  Interop , OLE DB etc all suck to one degree or… Read more

0 comments, 904 reads

Posted in Dave Ballantynes blog on 17 June 2016

SQL Server Indexing Book Giveaway – Week 3

In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away.  This is a book that I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which I think can… Read more

11 comments, 146 reads

Posted in StrateSQL on 17 June 2016

SSMS Tools Pack - A Handy Tool for generating CRUD

So I've had this tool around for a while, but never found much usage out of it to be honest. I didn't end up writing a review as I had other tools that did text replacements, and history/session saving. I've always considered this tools implementation of SQL History/Tabs saver the… Read more

0 comments, 150 reads

Posted in SQL Barbarian on 17 June 2016

Selective Logging with the UPDATE() Function

Triggers can be very useful when you want to log changes to your data, but what if you’re only interested in logging changes to certain columns? This is where the UPDATE function comes in. This function can only be used in DML triggers and it allows us to discover if… Read more

3 comments, 1,656 reads

Posted in The Database Avenger on 16 June 2016

When were statistics updated?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I ran across the STATS_DATE function recently, and it’s one that I hadn’t used in production code. I’m not sure how this escaped me, as it was… Read more

2 comments, 207 reads

Posted in The Voice of the DBA on 16 June 2016

Return Max or Min Value of a Group of Columns as a Single Column

Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never used again (turns out, there’s quite a lot of them in this database). They are characterized by having _bak or _ appended to the end of them. I wanted to…

Read more

Help! My backup file has doubled in size.

Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! What happened?

Did you know a single backup file can contain multiple database backups? When you backup a database to a file, if that file already exists, then by default… Read more

2 comments, 133 reads

Posted in SQLStudies on 16 June 2016

A Better (Free) Search in SSMS

A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we released. Free as in beer, so go get it.

Why use SQL Search?

There are a number of good reasons, which Ike Ellis of Crafting Bytes does a good… Read more

0 comments, 2,368 reads

Posted in The Voice of the DBA on 15 June 2016

What’s New in Reporting Services 2016

Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long list of new features and enhancements included with SQL Server Reporting Services 2016. The webinar has been recording and I’ve uploaded it to YouTube for your viewing pleasure.

If you’d… Read more

4 comments, 3,501 reads

Posted in SQL with Dustin Ryan on 14 June 2016

Power BI Custom Visuals Class (Module 03 – Hexbin Scatterplot)

In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual.  The Hexbin Scatterplot is a variation of the traditional Scatter Chart but instead of using bubble size it relies on color saturation and hexbins to show value distribution.  You should consider using this chart… Read more

0 comments, 1,564 reads

Posted in Devin Knight on 14 June 2016

Because

Because there’s nothing else I can do at the moment.

 

The post Because appeared first on Home Of The Scary DBA.

Read more

1 comments, 145 reads

Posted in The Scary DBA on 14 June 2016

OmniCompare: A free tool to compare SQL Instances

comparing instances

When working with a variety of instances, you can often deal with variances in configuration that might impact the performance. Without digging into each instance you wouldn't know immediately that this had happened. There are fantastic tools, like Brent Ozar's SP_Blitz, but this doesn't focus on every single… Read more

0 comments, 1,456 reads

Posted in SQL Barbarian on 14 June 2016

It’s 2016 RLS for T-SQL Tuesday #79

It’s T-SQL Tuesday time again. I missed last month, being busy with travel, though I should go ahead and write that post. Maybe that will be next week’s task.

In this case, Michael J Swart is hosting this month’s blog party and he asks us to write about something to… Read more

1 comments, 535 reads

Posted in The Voice of the DBA on 14 June 2016

Comparing two query plans

This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. The feature I want to talk about has been around for a bit. Not because it’s not part of SQL 2016 but because it’s part of… Read more

1 comments, 2,093 reads

Posted in SQLStudies on 14 June 2016

Newer posts

Older posts