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

Latest Blog Posts

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why is it important?  The most significant thing about it is that report and dashboard users do not need to have Excel 2013 ProPlus edition or an Office 365 subscription to…

Read more

0 comments, 69 reads

Posted in SQL Server BI Blog on 20 December 2014

SQL #55 – Data Types and Storage Reference

When we design a database, we usually need to do an estimate on the size of the database based on the dimension and fact tables.

Keep the following information handy next time when you need to do so.

The lists are based on this article:

SQL Server 2012 Data Types Read more

0 comments, 57 reads

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

Quick Audio Switching

I’ve got a semi complicated desktop setup, with multiple monitors, lots of USB stuff, and a few ways to record and listen to sound. I hadn’t thought of things as complex, especially with regards to audio, but between recording podcasts, having regular video conferences, and the speakers I added to… Read more

0 comments, 83 reads

Posted in The Voice of the DBA on 19 December 2014

First Ask “Why”, then Ask “How”

 

A common refrain we hear when presenting at technical conferences and training events is “How can I get promoted into IT management?” We hear this so often that we’ve worked out a sort of mental flowchart for the subsequent dialog. (We are IT people after all). And our exploratory… Read more

0 comments, 54 reads

Posted in Kevin E. Kline on 19 December 2014

I am joining SQLskills

I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to join an incredible team of SQL Server professionals and continue growing in my SQL career.  I am very excited to be working with some of the best in the industry… Read more

7 comments, 63 reads

Posted in Tim Radney - Database Professional on 19 December 2014

Reblog: December 12 to December 18

Photo credit – Travis

Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more

0 comments, 49 reads

Posted in StrateSQL on 19 December 2014

“Pretty Plans vs. Performance” or “Grant Gets Pwned”

If you get an execution plan that looks like this:

I wouldn’t blame you for immediately thinking about query tuning. Especially if the code that generated it looks like this:

SELECT  soh.OrderDate,
        sod.OrderQty,
        sod.LineTotal
FROM    Sales.SalesOrderHeader AS soh
INNER JOIN Sales.SalesOrderDetail AS sod
        ON sod.SalesOrderID = soh.SalesOrderID
WHERE   soh.SalesOrderID IN…

Read more

1 comments, 75 reads

Posted in The Scary DBA on 19 December 2014

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t know or need to know the attribute names. By using this axis you can access all of the attributes within the given context node. The specific scenario I had was… Read more

0 comments, 47 reads

Posted in SQL Server Rocks! on 19 December 2014

Whats New 2014

Hey all, Continue to my whats New series,  I will try to write blog a day for whats new is 2014 as well. I am going through its new features and the more I am reading it it impresses me a lot. … Continue reading

Read more

0 comments, 66 reads

Posted in Vinay Thakur on 19 December 2014

Friday Followup For December 19, 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

  • sp_BackupDatabases v1.3
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE)…

Read more

0 comments, 60 reads

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

Offer – Any e-book for $5

Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5 (£3.60 in British money).

This includes my book, Getting Started with SQL Server 2012 Administration 

The offer will run from Thursday 18th Dec 2014 to Tuesday 6th Jan 2015,… Read more

0 comments, 59 reads

Posted in The SQL DBA in the UK on 19 December 2014

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, 69 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, 68 reads

Posted in The Smiling DBA on 18 December 2014

Conferences & Presentations of 2014 in Review

Reviewing the year 2014, I can see that I have truly started improving my life by lowering the number of conferences attended & lowering the number of presentations delivered. I am also hoping that I have lowered the number of…

Read more

0 comments, 69 reads

Posted in Niko's blog 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, 129 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, 84 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, 224 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, 67 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, 106 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, 81 reads

Posted in Multidimensional Mayhem on 17 December 2014

Older posts