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

Latest Blog Posts

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, 110 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, 71 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, 147 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, 116 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, 73 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, 374 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, 107 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, 74 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, 99 reads

Posted in StrateSQL on 11 May 2015

Is Performance Better With LEFT JOIN or RIGHT JOIN?

I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:

Give me all the rows from this table and only those rows that match from the other table.

But, wouldn’t this logic work just as well:

Give me only the…

Read more

10 comments, 4,023 reads

Posted in The Scary DBA on 11 May 2015

Introduction to Azure DocumentDB

This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.

What is DocumentDB?

DocumentDB is a new “Big Data” database engine created by Microsoft and managed as a service within their Azure Cloud framework (currently available in their Azure Preview… Read more

0 comments, 198 reads

Posted in Eitan Blumin on 11 May 2015

Database snapshot captures only data changes or it will also save real database from DDL changes ?

Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure, store procedure etc.)

Answer : Yes.

So here we explian how :-

Databse snapshot is read only databse. It’s a static view database on which only read only operaton… Read more

0 comments, 2,331 reads

Posted in MSSQLFUN on 11 May 2015

Fresh New Horror: PK on a Float Data Type

Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after my previous two posts about the ills of the approximate-number data types.

Creating a primary key on a float data type can lead to what appear to be duplicate primary…

Read more

0 comments, 116 reads

Posted in SQL Tact on 11 May 2015

SQL Server 2016 Announced, and it stretches to the Cloud!

Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of SQL Server, and its SQL Server 2016.

Satya started the Ignite keynote, and he looked really pumped when he announced SQL 2016.

“SQL 2016 perhaps is the biggest breakthrough…

Read more

0 comments, 152 reads

Posted in on 10 May 2015

SQL Server in Azure

There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines, also described as Infrastructure as a Service (IaaS). The other is called Azure SQL Database, database-as-a-service or Platform as a Service (PaaS).  there are several important differences in functionality… Read more

0 comments, 139 reads

Posted in Gorandalf's SQL Blog on 9 May 2015

A Week to SQL Saturday #393 – Redmond

Only my second SQL Saturday of the year (wow), but SQL Saturday #393 is next week in Redmond, WA. This is my first time at a SQL Saturday in Washington, though I’ve been to the area many times. I’m looking forward to the trip up with a couple days in… Read more

0 comments, 191 reads

Posted in The Voice of the DBA on 8 May 2015

Bringing Together Databases, Virtualization and Storage

A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks that both DBAs and Infrastructure Administrators need to maximize the performance of their systems without significant re-architecting of their environments.  Check it out!

Read more

0 comments, 147 reads

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

002 – SQL Server 2016 - WaterOx Consulting

Reading Time: 1 minutes

It is official! The next version of SQL Server will be SQL...

The post 002 – SQL Server 2016 appeared first on WaterOx Consulting.

Read more

0 comments, 173 reads

Posted in WaterOx SQL on 8 May 2015

PSA: Update Your PASS Profile

I got my annual two emails from the PASS organization with the notification to update my profile to vote. I’m not sure why I get two emails to two different email addresses when I’ve only logged into one profile account in the last six or seven years, but I’m sure… Read more

2 comments, 153 reads

Posted in The Voice of the DBA on 7 May 2015

Video: Bringing Together Databases, Virtualization and Storage

Bala Narasimhan, Vice President of Products from PernixData, and I recently sat down and discussed the convergence of infrastructure, SQL Server, virtualization, and storage systems. We chatted about some of the ongoing challenges of high performance virtualized SQL Servers and the impact they can have on the rest… Read more

0 comments, 97 reads

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

Newer posts

Older posts