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

Latest Blog Posts

SQL F.A.D. – Average Transactions Per Day - WaterOx Consulting

Reading Time: 2 minutes

Sometimes Fast & Dirty is OK. Other times, not so much. Sometimes...

The post SQL F.A.D. – Average Transactions Per Day appeared first on WaterOx Consulting.

Read more

2 comments, 2,765 reads

Posted in WaterOx SQL on 13 May 2015

SQLSaturday#380 NYC Presents The Speaker Schedule

We're a little under 3 weeks away from what is sure to be the biggest and best Big Apple SQLSaturday event in NYC, on May 30, 2015!  It is with great pleasure to announce the SQLSaturday#380 super SQL Server Speaker Schedule!!  Indeed we have an exciting and awesome lineup… Read more

0 comments, 171 reads

Posted in Pearl Knows on 13 May 2015

Creating a SQL Agent Job Wrapper with PowerShell and SMO

Some Background

“Is there any way to start a SQL Agent job using a script or program?”

I’ve seen this question asked a number of times over the past couple weeks and I thought I would share an approach using PowerShell and SMO. But first, let’s take a step back… Read more

8 comments, 2,522 reads

Posted in on 13 May 2015

How to Find Objects that Contain a Certain String in SQL Server

Let’s say you remember a piece of code you need to optimize or take a look at, but you don’t remember in which stored procedure you saw it.

The following script searches for a certain string inside the code of all programmatic objects in the database (stored procedures, triggers, views… Read more

4 comments, 141 reads

Posted in Matan Yungman on 13 May 2015

SQL Server Reference Architecture on SimpliVity

Recently, I was able to help SimpliVity work to develop a reference architecture document for running resource-intensive SQL Server virtual machines on the SimpliVity OmniCube platform. We went through a lot of different OLTP workload types and have put together a number of best practices for virtualized SQL Server on… Read more

0 comments, 113 reads

Posted in Technobabble by Klee from @kleegeek on 13 May 2015

TSQL Tuesday #66: Monitoring

If a user is going to call me about problem, I’d much rather know about it ahead of time. In fact my favorite problems are the ones I’ve already fixed before the users ever notice it. In order to manage this amazing feat you have to monitor your instances, your… Read more

1 comments, 3,074 reads

Posted in SQLStudies on 12 May 2015

Monitoring SQL Server

Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related meme in the blogosphere – TSQLTuesday.

This month we are hosted by Catherine Wilhemsen (blog | twitter) from Norway. And interestingly, Catherine has asked for us to talk… Read more

1 comments, 106 reads

Posted in SQL RNNR on 12 May 2015

Monitoring Your Backups [T-SQL Tuesday #66]

Cathrine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday, and the topic she chose is monitoring. All of us, whether a DBA or a developer, internal resource or consultant, monitor something on a daily basis. The hardest part for me was deciding what to write… Read more

1 comments, 300 reads

Posted in The Data Files on 12 May 2015

T-SQL Tuesday #66 - Monitoring for a healthy SQL environment

Just heard that today was T-SQL Tuesday #66!  Well, I knew it was Tuesday, and T-SQL comes into play once a month, but then I heard the topic was monitoring.  I am so pleased that Cathrine Wilhelmsen (@cathrinew) is hosting this month’s blog party, and I… Read more

0 comments, 493 reads

Posted in Pearl Knows on 12 May 2015

Office Hours Webinar: Is Biml Right for You?

If you’ve read my blog or attended one of my presentations before, you almost certainly know that I’m a huge fan of Biml. If you’re building or maintaining SSIS packages (or you’re supervising those that do), you owe it to yourself to learn about Biml. I don’t make a lot… Read more

0 comments, 2,554 reads

Posted in Tim Mitchell on 12 May 2015

T-SQL Tuesday #66 – Monitoring SQL Server

This is a T-SQL Tuesday that not only makes me smile, but makes my boss happy. In fact, I’m sure that quite a few people at Redgate Software, my employer, are thrilled with this topic since we have a product that helps you here: SQL Monitor.

T-SQL Tuesday #66… Read more

1 comments, 138 reads

Posted in The Voice of the DBA on 12 May 2015

T-SQL Tuesday #66 – Monitoring

Thank you Cathrine Wilhelmsen for hosting this week’s #tsql2sday.

If I knew that this T-SQL Tuesday was going to be about monitoring I would have saved my Monitoring SQL Agent Jobs post from last month. No worries though! I think I’ll talk more generally about monitoring.

If you don’t monitor…

Read more

0 comments, 116 reads

Posted in on 12 May 2015

Putting Your Head in the Clouds 3 – Cloud Service Offerings

By David Postlethwaite
Cloud Service Models
There are three main service models in the cloud. You will see these buzz words being used a lot in cloud discussions:
  • IaaS   - Infrastructure as a Service
  • PaaS  Platform as a Service
  • SaaS  Software as a Service
To get a better understanding what…

Read more

0 comments, 78 reads

Posted in The SQL DBA in the UK on 12 May 2015

Delivering a precon on Columnstore Indexes at SQLSaturday Cambridge

I am extremely happy to share that I shall be delivering a workshop at the amazing SQLSaturday Cambridge on 10th of September 2015 (Thursday). As you would expect, this whole day experience will focus on my favourite functionality in the…

Read more

0 comments, 163 reads

Posted in Niko's blog on 12 May 2015

Taking (and passing!) the 70-461 Exam and Pursuing My MCSE Certification

Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam.  I decided recently to try and achieve getting my MCSE: Data Platform certification within the next six months.  Taking this exam was step one, and now I have four remaining.  Rather than spending a bunch of money on… Read more

0 comments, 122 reads

Posted in Adam Kreul | Blog on 12 May 2015

TSQL2sday #66 – Monitoring

A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic and it’s a very important one. It could mean the difference between having a job and looking for a job.

When I started working with SQL Server… Read more

0 comments, 77 reads

Posted in SQL Swimmer on 12 May 2015

T-SQL Tuesday 66 Monitoring – Agent Alerts

Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you need to get a wriggle on and upgrade to SQL Server 2014. If you are still wondering whether to upgrade I did write a post on it some time back… Read more

0 comments, 396 reads

Posted in Richard Douglas on 12 May 2015

Know about SQL server Objects

Introduction to SQL server Objects

In databases, when we talk about database objects, it means we are talking about SQL Tables. SQL Tables are also known as SQL Objects which manages all the records in a specific order in SQL server database. The data, stored in a Table are managed… Read more

0 comments, 116 reads

Posted in Zora's SQL Tips on 12 May 2015

The Murder Train is pulling into Iowa City

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more

0 comments, 81 reads

Posted in A Discussion of SQL Server-Related Topics on 11 May 2015

Monday Morning SQL Break – May 11, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 106 reads

Posted in StrateSQL on 11 May 2015

Newer posts

Older posts