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

Archives: February 2013

Cost Threshold for Parallelism


Parallelism, where to start?  Well let’s start right at the beginning shall we with the question, what is parallelism?  Simply put it is a feature of SQL Server which allows queries to utilize more threads in order to complete quicker.  There are several ways to influence SQL Servers decision whether…

Read more

0 comments, 801 reads

Posted in SQL Server 365 on 26 February 2013

Sparklines and Conditional Formating in SSRS

When creating a SSRS report, you want to add lines that display trends. You want to show trends for more than one data point. And you want to conditionally format the data point.

In this example, I use Sparklines and a simple expression to create a sparkling report!

Below is… Read more

0 comments, 55 reads

Posted in Sam Vanga on 26 February 2013

Sparklines and Conditional Formating in SSRS

When creating a SSRS report, you want to add lines that display trends. You want to show trends for more than one data point. And you want to conditionally format the data point.

In this example, I use Sparklines and a simple expression to create a sparkling report!

Below is… Read more

0 comments, 232 reads

Posted in Sam Vanga on 26 February 2013

Restart the SQL Server Agent Service using PowerShell

Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.

Whilst covering the Production Ops Shift in our shop over the weekend I discovered that Database Mail had not been configured for the SQL Server Agent on a number of servers.… Read more

3 comments, 1,027 reads

Posted in John Sansom - SQL Server DBA in the UK on 26 February 2013

SQL Server Videos

About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.

Today, I want to talk about the various video sources for SQL Server (luckily for us, there are lots of them).

The video medium is great because you can view sessions from… Read more

1 comments, 182 reads

Posted in DB NewsFeed on 26 February 2013

Data Warehouse Architecture Presentation

I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual chapter.  Below is the abstract.  It will be a remote presentation that you can join online.  Details are here.  This will be the same presentation that… Read more

0 comments, 493 reads

Posted in James Serra's Blog on 26 February 2013

A Rickety Stairway to SQL Server Data Mining, Algorithm 9: Time Series

by Steve Bolton

                The data mining method known as Time Series is aptly named, because it seems to take a long series of time to get it right.
                Out of the nine algorithms included in SQL Server Data Mining (SSDM), Time Series is on a par with Neural Networks in… Read more

0 comments, 1,350 reads

Posted in Multidimensional Mayhem on 26 February 2013

SQL Server features that are not supported by Azure SQL Database

SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that are not supported and here are some of them (short info):

SQL Server 2008 R2 features that are not supported by Azure SQL Database:

  • SQL Server Utility
  • Master Data Services

Read more

0 comments, 818 reads

Posted in Dukagjin Maloku - Dugi'DBA on 26 February 2013

70-461 Test SQL Ranking Functions

I created a post-webinar SQL Ranking Functions interactive test which relates to 70-461 Exam and thought I will share it. It is advanced level and hence rather challenging for many people. So far we had 11 attempts where best score is 60% (as of today) and average score is 23%.

Read more

0 comments, 636 reads

Posted in Katie and Emil on 25 February 2013

Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works

Functions might seem to be the answer to all of your desires to consolidate code, and at times they could be.  But if you don’t know enough about them, they may turn out to be the source of all of your problems and opening the door to architecture choke full… Read more

0 comments, 227 reads

Posted in StrateSQL on 25 February 2013

SQL Server Discovery Report

How can I check what all SQL server features and version are installed on my Machine ?

It’s a frequently asked question. You need to study your environment, need to login each instance to check version & other details, to answer this question.

Till SQL Server 2005, you have no… Read more

0 comments, 438 reads

Posted in MSSQLFUN on 25 February 2013

A Learning Experiment at SQL Saturday #187– Richmond

In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back as I attended school not too far from there (Charlottesville), and even worked on the West side of Richmond for a time. My brother lives in MD and my mother… Read more

2 comments, 662 reads

Posted in The Voice of the DBA on 25 February 2013

Benchmark SQL Server Disk Latency

Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking disk counters for SQL Server.  Typically, you will see people applying best practices like having dedicated spindles for transactional log files and dedicated spindles for data files.  With… Read more

7 comments, 2,279 reads

Posted in John Sterrett on 25 February 2013

Last Weeks Top 10 “Reading” Links #21

Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet.  Here are the top ten of the items that I linked out last week.  Typically, these are the tweets from things I read in the evenings and then share throughout… Read more

0 comments, 421 reads

Posted in StrateSQL on 25 February 2013

A Month of PowerShell – Day 25 (Integrity Checks)

Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

We all know that we… Read more

2 comments, 1,358 reads

Posted in A Discussion of SQL Server-Related Topics on 25 February 2013

SQL Saturday #187 Richmond And More

In just a couple of weeks I’ll be flying down to Richmond, VA to speak at SQL Saturday #187. I’ll be presenting two topics, Backups for the Accidental DBA and Query Tuning in the Clouds. It’s going to be a great event with a bunch of excellent speakers. If… Read more

0 comments, 474 reads

Posted in The Scary DBA on 25 February 2013

DROP and CREATE vs ALTER

When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic options.  I’ll start at the outset by saying I use all 3 and that they each have their pluses and minuses.  I’m not trying to advocate one or another, just… Read more

10 comments, 3,200 reads

Posted in SQLStudies on 25 February 2013

Building My Next Workstation–Part 2

Building a computer, at least in the beginning, feels like something you have to do holistically and at the same time like a chicken and the egg scenario. For example, what size power supply you buy depends on what you’re going to use for your video card. Not all video… Read more

2 comments, 273 reads

Posted in SQLAndy on 25 February 2013

SQL BLOG: Calculating total number of days from 1st Jan without using DATEDIFF function

Below script will calculate total number of days based on the input from user from 1st Jan. Though we have a built in function DATEDIFF from which we can calculate this easily. But in the below script, i have tried calculating the days without this built in function.

I have…

Read more

0 comments, 266 reads

Posted in SQL Blog by Rahul Sahay on 25 February 2013

Managing Critical Server Lists with Remote Desktop Connection Manager

Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which is formerly known as the Microsoft Terminal Services Connector accessible from the command mstsc in Run, or from a Command Prompt.  What most do not realise, however, is that there… Read more

0 comments, 862 reads

Posted in The Database Hive for SQL Server DBAs on 25 February 2013

Newer posts

Older posts