Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 66 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, 208 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, 179 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, 6,864 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, 167 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,197 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, 37 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

1 comments, 7,222 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, 27 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, 6,877 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, 166 reads

Posted in Matan Yungman on 28 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

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

0 comments, 7,083 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, 146 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

2 comments, 6,279 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,217 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, 59 reads

Posted in Zora's SQL Tips on 27 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,097 reads

Posted in The Voice of the DBA on 26 August 2014

SQLSaturday Orlando Marketing Plan-Part 39

Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very good week! Our standard Tuesday email will go out about 10 am this morning with topics on MVP’s in attendance and lunch. On Friday we’ll have our first “special”… Read more

0 comments, 183 reads

Posted in SQLAndy on 26 August 2014

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states that you can create and… Read more

0 comments, 6,598 reads

Posted in SQL Server Rocks! on 26 August 2014

Older posts