-->
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, 630 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, 675 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, 6,893 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, 893 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

2 comments, 939 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, 515 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, 548 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, 734 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, 523 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, 622 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, 458 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, 6,877 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, 708 reads

Posted in AshishSharePointBlog 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, 7,001 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, 395 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

2 comments, 587 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,357 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, 691 reads

Posted in SQLStudies on 29 December 2014

SQL Server 2014 Best Practice: Set built-in Sysadmin(sa) account as an default owner of all databases on SQL Server instance

As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the user full control on the database, meaning he/she can do whatever they like on that particular database. According to the SQL… Read more

1 comments, 1,259 reads

Posted in Basit's SQL Server Tips on 28 December 2014

Change Data Capture (CDC)–An easy way to track data changes of a database–TIP #79

 

In last TIP #78  we have discussed Change tracker (CT) which was introduced in SQL SERVER 2008. CT feature only tracks which row is changes means on which row Insert/update/delete operation is performed but it does not track what exact value is changed.

If we want an… Read more

0 comments, 554 reads

Posted in Rajat Jaiswal-337252 on 27 December 2014

Older posts