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

Latest Blog Posts

Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)

Continuation from the previous 50 parts, the whole series can be found at http://www.nikoport.com/columnstore/ This post is dedicated to usage of one of the most important technologies in ETL space – SQL Server Integration Services and its integration with the…

Read more

0 comments, 47 reads

Posted in Niko's blog on 19 April 2015

Rebuild Indexes of database with fragmentation more than 30%

Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application to respond slowly. We should reorganize indexed with fragmentation between > 5% and < 30% and rebuild indexes if fragmentation more than 30%. To rebuild indexes we…

Read more

0 comments, 58 reads

Posted in BI Expert on 18 April 2015

Windows Phone – What Should Microsoft Do?

I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the dearth of apps led me to an Android instead. I really tried to get down to a list of core apps that I needed, which was 12 or 15 at… Read more

0 comments, 124 reads

Posted in The Voice of the DBA on 17 April 2015

Heraflux is Hiring

I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development. When we first started our company in September 2013, we had a number of short and long term goals about how we wanted to grow and scale our… Read more

0 comments, 64 reads

Posted in Technobabble by Klee from @kleegeek on 17 April 2015

On Software and OS Lifecycle Management

An Important Rule: 

If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything, it will be more likely to entrench them against your position. Therefore, this is something that IT professionals should avoid. 

If You Write Your Own Software

or work… Read more

0 comments, 67 reads

Posted in Databases – Infrastructure – Security on 17 April 2015

Good things should be appreciated–SQL sentry Plan Explorer TIP #95

Although , It is out of box but I would like to share here. I am very choosy in food. When my mother/wife cooked food and I didn’t like the taste then I explicitly said I didn't like but when food taste was awesome then I didn't say a word.…

Read more

0 comments, 80 reads

Posted in Rajat Jaiswal-337252 on 16 April 2015

Error Creating Remote Distributor When Creating a Local Distributor

Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some lab servers to test my scripts, I ran into some issues. The thing that confused me at first was that it was complaining about a missing remote login for the…

Read more

April Blogger Challenge 3 – Filtered Indexes

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on.

Why Filtered Indexes

I haven’t used filtered indexes much in my career as they didn’t exist while I was a full time SQL developer and… Read more

0 comments, 122 reads

Posted in The Voice of the DBA on 16 April 2015

SQL Server 2014 SP1 released, and revoked

Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has been released, and then pulled almost immediately: The problem is there was a problem with the patch. I can’t go into details until there is something formally announced…

Read more

1 comments, 139 reads

Posted in SQL Awesomesauce on 16 April 2015

Azure SQL Database v12 and SQL Magazine

I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old books. Occasionally it’s a blog post like this one. Lately, it’s been a series of articles for SQL Magazine that are all about the new functionality available in Azure SQL… Read more

0 comments, 81 reads

Posted in The Scary DBA on 16 April 2015

Exam Prep 70-463: Master Data Services Models

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 98 reads

Posted in Cleveland DBA on 16 April 2015

Adding, altering or removing multiple columns from a table

I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing 4 old ones, renaming 4 and then altering the datatype for those 4. I find these kinds of requests rather entertaining in a simplistic sort of way. I try to… Read more

2 comments, 80 reads

Posted in SQLStudies on 16 April 2015

Stupid T-SQL Tricks – Part 3: A Zodiacal SQL

Today we’ll learn how you can use T-SQL to calculate your zodiac sign from your birthdate.

“Heeeeeere’s Johnny!” – Ed McMahon introducing Johnny Carson for the Tonight Show

If you’re old enough to remember the Tonight Show hosted by Johnny Carson, how can you not remember the iconic Stupid Pet… Read more

0 comments, 101 reads

Posted in DwainCSQL on 16 April 2015

Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Intro

This blog post is designed to be useful to two different audiences:

  1. Those implementing Ola Hallengren’s Maintenance Solution for the first time
  2. Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline

There’s… Read more

0 comments, 93 reads

Posted in Jared Zagelbaum's Blog on 16 April 2015

HammerDB Performance Collection with SQL Server

Recently, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL Server that one of my favorite database benchmarking utilities, HammerDB, uses to produce the transactions per minute counter value that the benchmarking utility outputs.

I thought I’d counter… Read more

0 comments, 89 reads

Posted in Technobabble by Klee from @kleegeek on 15 April 2015

SQL Prompt – Killing the Detail Box

I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts and stutters, and it’s painful.

However one of the defaults for SQL Prompt is to pop up details about objects when I’m typing, as shown below:

I usually want the… Read more

0 comments, 144 reads

Posted in The Voice of the DBA on 15 April 2015

Have you tried DLM Dashboard?

DLM Dashboard is a new product from Redgate Software that’s free. Free as in beer, which should be attractive to many of you. The product is in Beta, but it’s fairly stable and has worked well for me. It’s still maturing, and we’re certainly looking for feedback on what works… Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 15 April 2015

Types of NoSQL databases

A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.  NoSQL is often interpreted as Not-only-SQL to emphasize that they may also support SQL-like query languages.

NoSQL is simply the term that is… Read more

1 comments, 249 reads

Posted in James Serra's Blog on 15 April 2015

Quickly Check If SSL For SQL Is Enabled

Reading Time: 2 minutes

To quickly check SSL is configured on your SQL Server you can run the following query.

SELECT session_id, encrypt_option
FROM sys.dm_exec_connections

This query dumps the information about the connections to your SQL Server and any of them using a secured connection will have a ‘True’ value… Read more

1 comments, 90 reads

Posted in WaterOx SQL on 15 April 2015

Older posts