SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2015

Microservices and Databases

I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent items in software. However the idea of microservices causes issues with databases. Here’s the section in the piece by Netflix: Create a separate data store for each microservice.

I… Read more

3 comments, 2,687 reads

Posted in The Voice of the DBA on 31 March 2015

Apress April Fools 40% Discount Promo & Healthy SQL

April 1, 2015 – I am delighted to take part in the April Fool’s Promotion by Publisher Apress, who are featuring some of their new upcoming collection of terrific technical books for 40% off all eBooks through 4/15/2015.  You should take advantage of this exclusive limited time offer,… Read more

0 comments, 1,548 reads

Posted in Pearl Knows on 31 March 2015

Excel Tip #23: Adding a Trendline to Your Chart

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

2 comments, 7,426 reads

Posted in DataOnWheels on 31 March 2015

PASS Board Update: March 2015

Hello all,

It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books and this slipped through the cracks a bit. I’ll try to do better in the future.

Nothing major to report. As a board member I’ve been working primarily on… Read more

6 comments, 1,071 reads

Posted in The Scary DBA on 31 March 2015

Advice to New Bloggers


If you’ve been reading my blog for a while, you know that I travel and speak quite a lot. A frequent question I’m asked at these events is “I want to start blogging, but don’t know where to start. What do you recommend?” This is a such a common… Read more

1 comments, 1,252 reads

Posted in Kevin E. Kline on 31 March 2015

SSRS report footer is NOT lost in Excel

With all the recent changes and updates within the Microsoft PowerBI universe, SSRS core technology gets less and less attention. However a recent experience with one of the SSRS report’s functionality triggered my interest to share it.

I always thought that WYSIWYG principle for SSRS report exporting formats only worked…

Read more

0 comments, 11,472 reads

Posted in Data Adventures on 31 March 2015

Why I Want to Have Coffee With You

Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes that he doesn’t have the time or the desire to simply “have coffee”. While I empathize with some of the author’s justifications for his position, I was disappointed… Read more

10 comments, 7,860 reads

Posted in Tim Mitchell on 31 March 2015

An Easter SQL

Since Easter is nearly upon us, I got to thinking once again about how challenging it is to calculate the day that Easter Sunday falls on.  Since Calendar tables and their step-children Holiday tables are so interesting I thought I might write a sequel to my earlier blog link in… Read more

2 comments, 2,237 reads

Posted in DwainCSQL on 31 March 2015

Intro to SQL Server Automation with PowerShell

March 26th, 2015, a date which will live in infamy!

Well, at least for me it will. March 26th, 2015 marks the date I gave my first presentation at my local SQL PASS user group meeting. Here is the picture as proof!

I was very excited to be able to… Read more

0 comments, 850 reads

Posted in cjsommer.com on 30 March 2015

Outlier Detection with SQL Server, part 5: Interquartile Range

By Steve Bolton

…………The last seven articles in this series of mistutorials on identifying outlying values in SQL Server database were clunkers, in the sense that the methods had many properties in common that made them inapplicable to the scenarios DBAs typically need them for. Chauvenet’s Criterion, Peirce’s Criterion,… Read more

2 comments, 2,992 reads

Posted in Multidimensional Mayhem on 30 March 2015

SQLPort – 5 Years

On 21st of April 2015, SQLPort is preparing a very special event. The reason for this is that on 21st of April 2010, during the last TechDays in Portugal, the creation of the SQLPort – Portuguese SQL Server Community was officially announced.
We count this day as the official… Read more

4 comments, 1,068 reads

Posted in Niko's blog on 30 March 2015

Toshiba Portege Z30 Review

I saw recently that Grant Fritchey wrote a review of his laptop, the Portege Z30. I had noted Grant’s issues with laptops and waited to see what he got last year before I replaced mine. I actually had the chance to compare his Z30 with my old Lenovo T430… Read more

0 comments, 1,542 reads

Posted in The Voice of the DBA on 30 March 2015

ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance

Here are some oldies, but goodies that I recommend you read:

Two Partitioning Peculiarities and Aggregates and Partitioning

Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in… Read more

0 comments, 1,054 reads

Posted in Kevin E. Kline on 30 March 2015

Backups – They Are Needed, Who Knew?

Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at the end of the day if the data professional does not have a form of backup in place for his/her business needs you may, no you will, feel the pain.… Read more

4 comments, 7,105 reads

Posted in The SQL Professor on 30 March 2015

Does the New Cardinality Estimator Reduce Bad Parameter Sniffing

No. Next question.

Although, that answer can be slightly, ever so slightly, nuanced…

Parameter sniffing is a good thing. But, like a good wine, parameter sniffing can go bad. It always comes down to your statistics. A very accurate set of statistics with very little data skew (some values that… Read more

0 comments, 7,210 reads

Posted in The Scary DBA on 30 March 2015

Port numbers and SQL Server

I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are shocked, but it does happen on rare occasions. So what was I wrong about you might ask? One of the dev groups I support has been referring to their instances… Read more

0 comments, 8,227 reads

Posted in SQLStudies on 30 March 2015

Latches, Spinlocks & Lock-Free Data Structures Recording

A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data Structures in SQL Server. Fortunately my 2.5 hour long non-stop session was recorded, and is now finally available at Youtube for watching.



Read more

4 comments, 1,231 reads

Posted in Klaus Aschenbrenner on 30 March 2015

Can Log Shipping Work Without Shipping the Log?

When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:

Backup: Performs a backup log operation on the primary server, logs history and deletes old backup files and history information

Copy: Copies the backup files to the secondary server and logs history

Restore: Restores… Read more

0 comments, 6,854 reads

Posted in Matan Yungman on 30 March 2015

System Center for the SQL Server DBA Part I: SCOM

Originally posted on Blog Home for MSSQLDUDE:
I’ll start part 1 of the Microsoft System Center series, focused on what a SQL Server DBA should know about System Center, with System Center Operations Manager, or SCOM, with the SQL Server Management Pack. When you have licensed the System Center…

Read more

0 comments, 914 reads

Posted in Coffee and SQL on 30 March 2015

Older posts