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

Latest Blog Posts

Nominated for the 2014 Tribal Awards

Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:

The Tribal Awards, co-hosted by Simple-Talk and SQLServerCentral, seek to recognize outstanding members of the SQL community. We want to highlight people who are currently leaders due to their writing, speaking, or general community…

Read more

0 comments, 28 reads

Posted in Koen Verbeeck on 18 December 2014

PASS – Connect, Share and Learn

The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what does this mean to me and the SQL Server professionals I have meet in this community (#SQLFamily)?

 

First, I connected. Where did that start? SQLServerCentral.Com (SSC). I started… Read more

0 comments, 35 reads

Posted in The Smiling DBA on 18 December 2014

SQL Konferenz

I’ve spoken at lots of events, but all in the US and the UK. Next year I get my first talk outside of those locations, going to the SQL Server Konferenz near Frankfurt, Germany.

The agenda is up, and I’ll be talking testing and tSQLt there, and it’s cool to… Read more

0 comments, 104 reads

Posted in The Voice of the DBA on 17 December 2014

SSIS #118–Is it an OLEDB or an SMO Server Connection?

OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every task in Integration Services can use an OLEDB connection. As a matter of fact, it’s a preferable client to use if your backend is SQL Server.

However, there is one… Read more

0 comments, 66 reads

Posted in Sherry Li's BI Corner on 17 December 2014

Analytics Platform System (APS) AU3 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU3), which is sort of like a service pack, except that it includes many new features.  These appliance updates are made available frequently, about every 3-4 months.… Read more

0 comments, 62 reads

Posted in James Serra's Blog on 17 December 2014

2014 Tribal Awards Are Open

Yesterday morning I opened my email and was very pleased to find that I have been nominated for the 2014 Tribal Awards from Simple-Talk and SQL Server Central, in the category of ‘Beyond the call of duty / Outstanding Contribution‘. WOW!  I’m honored! Now, I’m not going… Read more

0 comments, 52 reads

Posted in Technobabble by Klee from @kleegeek on 17 December 2014

Building Your First Windows Azure Machine

Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted out on SQLAuthority.com. This tip was my first one working with Azure.  To me its remarkable how quickly you can spin up an instance to help you build…

Read more

0 comments, 80 reads

Posted in John Sterrett on 17 December 2014

Outlier Detection with SQL Server, part 3.2: GESD

By Steve Bolton

…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns, I mentioned that Grubbs’ Test has a number of limitations that sharply constrain its usefulness to DBAs. The Generalized Extreme Studentized Deviate Test (GESD) suffers from some of… Read more

0 comments, 63 reads

Posted in Multidimensional Mayhem on 17 December 2014

Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of VLFs (virtual log files). These VLFs are a logical way for SQL to break the physical file down into smaller pieces. These pieces are then marked as “in use” or… Read more

0 comments, 62 reads

Posted in SQLStudies on 17 December 2014

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in, into Tortoise with care,
in hopes a release date – soon would be there.

The devs were all slumped – in front of computers,
while prospects of bonuses… Read more

0 comments, 75 reads

Posted in SQLStudies on 16 December 2014

Load Balanced IIS Machines

I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the chance to win a Surface Pro 3. I could always use another device, or at least a device I could give away, so I decided to enter.

There are… Read more

2 comments, 93 reads

Posted in The Voice of the DBA on 16 December 2014

WordPress, Project NAMI, and Azure

I’ve been running WordPress for years now and find it to be a solid solution for what I want to do. The only negative in my view is the requirement to use mySQL. There’s nothing wrong with mySQL itself, it more than does the job. I can quibble that it… Read more

0 comments, 262 reads

Posted in SQLAndy on 16 December 2014

ROW_NUMBER SQL Server

Row_Number SQL Server

SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number() function.  You can use this function to return a sequential number in your result set that begins at 1.

There are 2 arguments that can be passed into the… Read more

1 comments, 115 reads

Posted in Business Intelligence and Enterprise Architecture on 16 December 2014

SQL Server Developer Tips that Can Save Your XXX

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for developers organized by E4D Solutions. I suggested the title “SQL Server Developer Tips that Can Save Your Ass”, but the organizers didn’t like it, so they changed it… Read more

0 comments, 104 reads

Posted in Guy Glantser on 16 December 2014

RegEx Those Dates

Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing. I decided to use SQL Data Generator, and a little RegEx to meet my needs.

The format I needed was CYYMMDD, which is the century as a 0 or 1… Read more

0 comments, 139 reads

Posted in The Voice of the DBA on 15 December 2014

Transaction Isolation Level Blues

Have you ever had a mental block in one particular area when learning something? It might be the simplest thing, but for some reason your brain turns to Teflon when you try to store the information. For example, I have a degree in Math, so I am pretty good at… Read more

0 comments, 90 reads

Posted in SQL Swimmer on 15 December 2014

Why You Should Benchmark Your Storage

You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And next week.

Well, that’s exaggerating things a bit… but storage performance should be at the core of your ongoing performance metric collection and test process. Storage performance matters that much… Read more

0 comments, 112 reads

Posted in Technobabble by Klee from @kleegeek on 15 December 2014

Create a clustered index and a primary key on existing tables

It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear, explicit reference…

Read more

0 comments, 155 reads

Posted in SQL Awesomesauce on 15 December 2014

The Value of Writing Good

Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re proficient readers who can digest the driest of technical material. They’re probably good with math, and a large portion of them are likely science geeks. How many of them can… Read more

2 comments, 73 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 15 December 2014

DBTA – Microsoft SQL Server and the Big Data Play

 

When it comes to implementing a big data strategy in a Microsoft SQL Server shop, you’re generally going to consider one of three strategies. In the first strategy, which I won’t be addressing today, you might choose to tackle your big data architecture by pushing your relational database to… Read more

1 comments, 82 reads

Posted in Kevin E. Kline on 15 December 2014

Older posts