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

Latest Blog Posts

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, 82 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, 80 reads

Posted in SQLStudies on 17 December 2014

SQLSaturday Portugal 2015 – Above & Beyond

At the same day, 4 years ago me & my team were already in the process of organising the very first SQLSaturday outside of Northern America – little did we know how much changes would happen in those passed years.…

Read more

0 comments, 64 reads

Posted in Niko's blog on 17 December 2014

Azure Columnstore, part 2 – Snapshot Isolation & Batch Mode DOP

Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1 – The initial preview offering. If you are interested in all the articles, feel free to visit my whole Columnstore…

Read more

0 comments, 59 reads

Posted in Niko's blog on 16 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, 86 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, 114 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, 326 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, 133 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, 122 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, 284 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, 103 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, 245 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, 170 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

3 comments, 81 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, 98 reads

Posted in Kevin E. Kline on 15 December 2014

Does a clustered index sort the rows within a page

This is just something I was curious about. I ran my tests and got an answer and now I thought I would share.

Before I start I want to point out a few things about my tests. I’m using code to create/modify a PRIMARY KEY. PRIMARY KEYs are not necessarily… Read more

0 comments, 174 reads

Posted in SQLStudies on 15 December 2014

SSAS #39–Building Optimal and Well-Tuned Dimensions

The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2 and for 2012.

  • Microsoft SQL Server 2005 Analysis Services Performance Guide
  • Microsoft SQL Server 2008 R2 Analysis Services Performance Guide
  • Microsoft SQL Server Analysis Services Multidimensional Performance and Operations…

Read more

0 comments, 121 reads

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

Little Java Boy

I didn’t want to repeat the Night Before Upgrade again this year, so I wrote something knew. Go ahead, sing along, you know the tune!

Go, they told me, pa rum pum pum pum
The D-B-A to see, pa rum pum pum pum
Your query runs too slow, pa rum… Read more

0 comments, 77 reads

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

SSIS #117–What is the Location in the MSOLAP Connection String

MSOLAP is a native OLE DB provider for Analysis Services

A common task during ETL is to process the OLAP dimensions and the cube after all the dimension and fact tables are loaded into the data warehouse. Integration Services provide two special control flow tasks for this purpose, the Analysis… Read more

0 comments, 85 reads

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

Azure Columnstore, part 1 – The initial preview offering

With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I am opening a new subseries in my Columnstore – Azure Columnstore. If you are interested in the basics of Columnstore…

Read more

2 comments, 7 reads

Posted in Niko's blog on 12 December 2014

Newer posts

Older posts