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

Latest Blog Posts

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

0 comments, 27 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

2 comments, 33 reads

Posted in The Scary DBA on 31 March 2015

Advice to New Bloggers

PREAMBLE

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

2 comments, 38 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, 62 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

1 comments, 41 reads

Posted in Tim Mitchell on 31 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

0 comments, 62 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…

Read more

4 comments, 77 reads

Posted in Niko's blog 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, 54 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

1 comments, 53 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, 45 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, 63 reads

Posted in SQLStudies 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, 83 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, 83 reads

Posted in Coffee and SQL on 30 March 2015

System Center for the SQL Server DBA, cont’d SCOM Pack for SQL

Originally posted on Blog Home for MSSQLDUDE:
My original posting on System Center Operations Manager for SQL Server DBAs start in part 1 of the series here. Today, I want to take just a minute to give you some pointers in getting started using the System Center Monitoring Pack…

Read more

0 comments, 76 reads

Posted in Coffee and SQL on 30 March 2015

PASS Excel BI VC presents Devin Knight on Getting Started on PowerQuery

Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.

Thu, Apr 02 2015 12:00 Central Daylight Time


Getting Started with Power Query by Devin Knight

RSVP: https://attendee.gotowebinar.com/register/1373099073018225154

GETTING STARTED WITH…

Read more

0 comments, 82 reads

Posted in The Smiling DBA on 29 March 2015

SQL Server 2014 BI ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2014 BI. ????? ??? ?????? ????????? ?????? ???????? ????? ??? ???????? ?? ??????? ???????? ???????? ???????? ????????? ?? ????? ???????? ???? ?????? SQL Server BI ?? ?????? ??????? ??? ???? ???…

Read more

3 comments, 66 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 29 March 2015

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You can read it here.

Stay tuned! :)


Read more

0 comments, 213 reads

Posted in Alessandro Alpi on 26 March 2015

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception.

Here’s a short example. I’ve… Read more

0 comments, 175 reads

Posted in The Voice of the DBA on 25 March 2015

I am a Superhero

Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this time there were around 1,700 attendees in a special edition of SQLBits – the Superheroes edition.

Between the various sessions and the exhibition hall, I met a lot of people… Read more

0 comments, 171 reads

Posted in Guy Glantser on 25 March 2015

Older posts