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

Archives: August 2014

Overview on SQL Server Performance Tuning

SQL Server Performance Tuning is an important subject and it is essential to implement various measures in regular intervals of time to optimize the scalability and performance of the Server.
Several parameters that can be executed for stimulate Server performance are mentioned herein.

Server Level Configuration Check:

For tuning the…

Read more

0 comments, 509 reads

Posted in Zora's SQL Tips on 30 August 2014

Reblog: August 22 to August 28

Photo credit – Husso

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more

0 comments, 735 reads

Posted in StrateSQL on 29 August 2014

Friday Followup For August 29, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Cheating DBCC To Fix Index Corruption
  • Automated Source Control: A Librarian…

Read more

0 comments, 602 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 August 2014

4 Attitudes I Wish I Had Earlier as a DBA

I was tagged by Mike Walsh (blog | twitter) in his post 4 Attitudes I Wish I Had Earlier As a DBA.

I Don’t Have to Do It Alone

I’ve always worked hard in my IT career to be knowledgeable in my field. I don’t like not… Read more

6 comments, 7,556 reads

Posted in Databases – Infrastructure – Security on 28 August 2014

I Didn’t Hyperventilate!

I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user group meeting and I didn’t hyperventilate! That’s a huge deal for someone like me, who is petrified of public speaking.

It started out a little rough though. Read more

0 comments, 739 reads

Posted in SQL Swimmer on 28 August 2014

I did my part – Helping others

Let’s raise some money, people.

TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.

What started out as a joke has grown, and we’re really looking to raise some money for this charity. I did my part

I started shopping, and I’ll be rainbow decked for the… Read more

0 comments, 4,735 reads

Posted in The Voice of the DBA on 28 August 2014

Dear IT Guy, Why do you hesitate to attend my meetings?

I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT geeky guys and gals don’t like to attend meetings, and deal with people etc.  This was her opinion based on her 20 year career in IT, and even as a…

Read more

0 comments, 408 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 28 August 2014

The Art of Performance Tuning

Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play. And whilst I don’t disagree that a certain level of knowledge is involved, I completely disagree that only certain people can performance tune.

Given the correct approach, anyone should be… Read more

2 comments, 8,007 reads

Posted in The DBA Who Came In From The Cold on 28 August 2014

What I Wish I Had Known Sooner…as a DBA

Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came across and article by Erin Stellato. She had been tagged by Mike Walsh who posted an article regarding 4 Attitudes I Wish I Had Earlier as a DBA

At… Read more

2 comments, 483 reads

Posted in The SQL Professor on 28 August 2014

Four things I wish I’d known back then

In the blogging meme of the day, I was tagged by my friend Tim Costello to share four things I wish I’d known back when.  The only hard part was paring the list down to four items.

I think back to 15 years ago, when I was working retail and… Read more

7 comments, 7,523 reads

Posted in Tim Mitchell on 28 August 2014

My SQLBits Session Recordings

Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.

A few days ago, all of the session recordings were uploaded to the SQLBits site.

In my first session, “Query Progress Tracking in SQL Server“, I talked about… Read more

0 comments, 573 reads

Posted in Matan Yungman on 28 August 2014

SSIS GoogleAnalyticsSource 1.7

A couple of days ago, Tillmann has released a new version of his amazing SSIS data source for Google Analytics – GoogleAnalyticSource.

After 5 months and some extensive investments here are some of the news that this release contains:

Read more

36 comments, 18 reads

Posted in Niko's blog on 27 August 2014

Transactional Replication in SQL Server 2014

Transactional replication begins with the help of publication database objects and data snapshots. The subsequent data changes and schema modifications created at Publisher are deployed to the Subscribers in real time. The order of the data changes in the same way it has been applied to the subscriber and exists…

Read more

2 comments, 1,821 reads

Posted in Zora's SQL Tips on 27 August 2014

SSRS report: Multi-value parameter going after Data-driven subscription

It is always good to enrich SSRS reports with multi-value parameters; users have more flexibility to combine different reporting scenario with no need to run a report for different parameter values separately. On the other hand, developers can craft their skills to embed multi-value parameters into report datasets; referencing different…

Read more

4 comments, 16,129 reads

Posted in Data Adventures on 27 August 2014

Presenting At OPASS August 2014 Meeting On 8/28

Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User Group (OPASS). Identity values seem like a straightforward topic but as SQL Server has evolved different methods for working with them have been introduced and each has caveats to… Read more

0 comments, 576 reads

Posted in Kendal Van Dyke on 27 August 2014

Finding a job!

I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years and 15 jobs or so (some contract positions) I’ve never been out of work for more than a month and a half at a time. I’ve always thought the methods… Read more

3 comments, 6,889 reads

Posted in SQLStudies on 27 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 3

As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are written for Perforce.  I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can easily transfer this to your own… Read more

0 comments, 6,726 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 August 2014

SQL Server Recovery Models - Specifications and Significance!

SQL Server provides an efficient way of backing up the databases by logging all the transactions in log file but it becomes equally important to decide which data has to be backed up and which not by limiting the logging process. In this section we will discuss about the SQL…

Read more

0 comments, 507 reads

Posted in Zora's SQL Tips on 27 August 2014

Clustered Columnstore Indexes – part 39 (“Memory in Action”)

Continuation from the previous 38 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/

In this post I shall try to discover more interesting information about Columnstore Object Pool behaviour and it’s relations to the total size of the available memory as well as the relationship to the Buffer Pool.

For the start, I will… Read more

2 comments, 20 reads

Posted in Niko's blog on 26 August 2014

Better Presentations–Hide those Windows

This is part of a series of tips for speakers to make your presentations better.

I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, and that might mean the difference between someone learning… Read more

8 comments, 6,664 reads

Posted in The Voice of the DBA on 26 August 2014

Older posts