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

Archives: December 2014

5th Blogging Year

It’s hard to believe that it’s been 5 years since my first ever post, in which I simply spelled Business Intelligence. Thanks to everyone for being with me since then!

I blogged around my daily experience as a Data Warehouse and Business Intelligence developer. Most of my posts are about… Read more

0 comments, 822 reads

Posted in Sherry Li's BI Corner on 31 December 2014

[SQL Snacks Video] Performance Tuning 103 – T-Logs and VLFs

Finally the arrival of Part 3 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. The first video was about performing a baseline using the PAL tool.I would highly recommend you review that video as…

Read more

0 comments, 955 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 31 December 2014

SQL #56–Aggregation with ROLLUP operator is not fully supported

ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP BY clause.

The GROUPING SETS operator might be introduced later in SQL Server 2008.

I only have experience with the ROLLUP operator. My test of GROUPING SET also suggested that… Read more

0 comments, 7,741 reads

Posted in Sherry Li's BI Corner on 31 December 2014

Preparing a Technical Session Part 2: Coming up with a Title

Earlier this month I began a blog series on preparing to do a technical talk. In that first post I discussed some strategies for coming up with a topic, which is ultimately the first step in your preparation.

In this post I’ll walk you through some tips for coming up… Read more

1 comments, 1,093 reads

Posted in Devin Knight on 31 December 2014

T-SQL Tuesday #61 – The Wrap-Up

Earlier this month, I hosted the 61st occurrence of the monthly TSQL-Tuesday blogging party. With a topic of “Giving Back”, it had a great turnout (27 party-goers). As I read through all of their posts, I noticed that many are planning to give back in pretty predictable ways… Read more

1 comments, 1,152 reads

Posted in A Discussion of SQL Server-Related Topics on 31 December 2014

Happy New Year

Just short post from me and the pooches to wish you all a very happy new year.

Have a great one!

Geth

Read more

0 comments, 721 reads

Posted in The SQL DBA in the UK on 31 December 2014

2014 – One more Year with you

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 73,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 3 days for…

Read more

0 comments, 747 reads

Posted in MSSQLFUN on 31 December 2014

2014 – A year in review.

G’day,

And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a good time to start.

2014 has been a pretty hectic year for me, both personally and professionally. The project that I’ve been working on for the past few… Read more

0 comments, 1,052 reads

Posted in measure twice, cut once. on 31 December 2014

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 160,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 7 days for…

Read more

0 comments, 708 reads

Posted in SQLStudies on 30 December 2014

Speaking Stats

I was updating my speaking schedule and CV, trying to get an idea of what might be planned for 2015. As I was doing so, I decided to do a quick count of events and talks to see where I was last year. Last year was tough, and I… Read more

0 comments, 850 reads

Posted in The Voice of the DBA on 30 December 2014

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 50,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 19…

Read more

0 comments, 640 reads

Posted in PowerSQL By Prashanth Jayaram on 30 December 2014

[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB

Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. The first video was about performing a baseline using the PAL tool.I would highly recommend you review that video as…

Read more

4 comments, 7,180 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 30 December 2014

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 19,000 times in 2014. If it were a concert at Sydney Opera House, it would take about 7…

Read more

0 comments, 894 reads

Posted in AshishSharePointBlog on 30 December 2014

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come up with a set of rules or start with these (https://tsqlsmellsssdt.codeplex.com/) and when you check-in your code, as part of your normal build or CI build you run the…

Read more

0 comments, 9 reads

Posted in Ed Elliott's Sql Developer Blog on 30 December 2014

Enforcing T-SQL quality with SSDT Analysis Extensions

What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come up with a set of rules or start with these (https://tsqlsmellsssdt.codeplex.com/) and when you check-in your code, as part of your normal build or CI build you run the…

Read more

0 comments, 9 reads

Posted in Ed Elliott's Sql Developer Blog on 30 December 2014

Powershell – Copy the Latest Backup

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess I’d written something about this in 2009, though that would have been for testing as Red Gate had already banned me from development on SQLServerCentral by that time.

I dug… Read more

5 comments, 8,417 reads

Posted in The Voice of the DBA on 29 December 2014

Brand Level Zero

It’s that time of year when people look back on the past year(s) and think about what they have and have not accomplished.

Going into 2015 I feel like this is going to be my breakout year- why and why now?

Why not just stay silent and in the shadows-… Read more

0 comments, 593 reads

Posted in Todd Kleinhans on 29 December 2014

DBTA – Other News in SQL Server 2014 RTM

 

A while back, I told you about some of the coolest new features in the recent RTM for SQL Server. The RTM was announced during the “Accelerate your insights” webcast by a boatload of Microsoft’s top executives, including CEO Satya Nadella, COO Kevin Turner, and CVP Quentin Clark. They… Read more

0 comments, 798 reads

Posted in Kevin E. Kline on 29 December 2014

Finding a common AD group for a set of users.

I work for a large organization that over the last few years has been doing a LOT of reorgs. And what comes with reorgs? Lots of security requests. I’m always working to find easier ways to deal with them and I’ve gotten pretty good at it over time. One common… Read more

8 comments, 5,615 reads

Posted in SQLStudies on 29 December 2014

Do you want to build an Audit?

So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql server I do a walkthrough of the SQL Server Audits feature. It’s probably one of the easiest systems to implement that SQL Server has but it does have… Read more

0 comments, 932 reads

Posted in SQLStudies on 29 December 2014

Older posts