SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2016

SQL Filegroup/File Proportional Fill Algorithm

[read this post on Mr. Fox SQL blog]

I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup in a user database.  There was a mention that data was not being distributed evenly… Read more

1 comments, 2,268 reads

Posted in Mr. Fox SQL on 24 February 2016

Grabbing Fitbit Data

Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.

I saw Rob Farley build a dashboard based on his Fitbit data. That was intriguing, so I went to get my data. I’ve worn a Fitbit for a couple years, recently having lost it.… Read more

2 comments, 958 reads

Posted in The Voice of the DBA on 24 February 2016

SQL – List Server and DB Permsission

Database Level Permission

DECLARE @DBuser_sql VARCHAR(4000)
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200)
SET @DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,…

Read more

1 comments, 542 reads

Posted in PowerSQL By Prashanth Jayaram on 24 February 2016

HP Superdome X for high-end OLTP/DW

No, Superdome X is not the name of the stadium where they played in the last Super Bowl.  Rather, Superdome X is HP’s top of the line server running Windows Server 2012 R2 and SQL Server 2014.  It can handle up to 288-cores and 24TB of memory!  It use the… Read more

2 comments, 1,184 reads

Posted in James Serra's Blog on 24 February 2016

Query Store and Recompile

One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be able to answer questions from the people there in great detail. One question came up while I was showing the new functionality of Query Store (available soon in SQL Server… Read more

5 comments, 522 reads

Posted in The Scary DBA on 24 February 2016

Powershell script to create multiple SQL Server Connections

As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is better than sp_who. Particularly when you have a large number of connections. Well in order to do that I need a large number of… Read more

1 comments, 682 reads

Posted in SQLStudies on 24 February 2016

TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me aware of the fact that I missed a HUGE opportunity in making the round up in a Power… Read more

0 comments, 370 reads

Posted in SQL Chicken on 24 February 2016

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its abstract goes like this:

Join us for this webcast to learn about best practices for SSIS, SSRS and SSAS.

Our presenter, Koen Verbeeck has several years of…

Read more

0 comments, 594 reads

Posted in Koen Verbeeck on 24 February 2016

Columnstore Indexes – part 77 (“SSIS 2016 & Columnstore”)

Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/

I have written previously about SQL Server Integration Services and their interaction with Columnstore Indexes in Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”), but for a long time I was looking… Read more

2 comments, 598 reads

Posted in Niko's blog on 23 February 2016

An annoying Bug in the Restore Dialog

Today, thanks to a customer, I discovered  one of those annoying little things that can really drive you nuts.

Basically, they were trying to restore a backup using the SSMS Restore Database window and they kept getting “No backupset selected to be restored” whenever a backup file was selected.

You… Read more

8 comments, 2,073 reads

Posted in SpaghettiDBA on 23 February 2016

SQL Saturday Headshots

This past weekend was SQL Saturday #478 – Albuquerque, and I was happy to have the chance to attend again. I was at the first two, missing last year with another event. It was good to go back, and carpool down to Taos for a day of skiing beforehand.… Read more

2 comments, 647 reads

Posted in The Voice of the DBA on 23 February 2016

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.

The request was for more details on the method I use to capture wait and file stats on servers, The methods are pretty similar, so I’ll show waits.

This is by no… Read more

4 comments, 2,073 reads

Posted in SQL In The Wild on 23 February 2016

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.

The request was for more details on the method I use to capture wait and file stats on servers, The methods are pretty similar, so I’ll show waits.

This is by no… Read more

4 comments, 79 reads

Posted in SQL In The Wild on 23 February 2016

Refreshing KPI Data in SSRS 2016

Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to configure scheduled data refresh for the KPI that was created in that blog post.

1.  SQL Server Agent must be running
2  Credentials must be stored in the… Read more

1 comments, 3,350 reads

Posted in SQLDownSouth on 23 February 2016

How is SQL Server using more than the Max Server Memory?

As usual, the pager went off...

"Server is near 100% memory utilization - what is running?"
I saw when I signed on that the Windows server was at 98% memory utilization (the sum of all processes in Windows, including but not limited to SQL Server) and that the sqlservr.exe…

Read more

0 comments, 3,272 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 February 2016

Installation of SQL Server (Part 1 - Pre-installation)

I have been wanting to write this for a long time, and finally got time to do it. Which is the pre and post configuration of new SQL server installation. Many of configuration was left as default in the hope that Microsoft should already tune it as the baseline for…

Read more

0 comments, 2,375 reads

Posted in Dennis's SQL Blog on 23 February 2016

Shrink a log file…AUTOMATICALLY?

Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First things first: why would you want to shrink a log file in the first place? Haven’t we heard that shrinking files is bad? Well, no and yes.…

Read more

2 comments, 2,538 reads

Posted in SQL Awesomesauce on 22 February 2016

SSRS 2016 – Part 2 New Features for Paginated Reports

This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the Community Technical Preview (CTP) 3.3.

Post 1 covered the basics of creating your first paginated report.

Post 3 will cover the new Mobile Reports and KPI features. Read more

3 comments, 964 reads

Posted in The Database Avenger on 22 February 2016

Memory Fundamentals for SQL Server - SQL Server Memory Components, SQL Server Memory Logical Tree

In the Previous blogs we have seen about virtual memory related concepts.

We came across concepts like Address Window Extension, Physical Address Extension.

We also saw the various CPU related architectural concepts and briefly touch based SQLOS.

In this blog we shall see how SQL server memory…

Read more

1 comments, 2,767 reads

Posted in Kruti's SQL Blog on 22 February 2016

Adding Minutes in Excel

A short one, but I found myself wasting time recently. I use an Excel sheet to schedule some items out each day. It’s not my choice to do this, but the service I use requires this to not manually set time for each event.

Tl;dr: Add minutes/1440 to the date. Read more

0 comments, 1,779 reads

Posted in The Voice of the DBA on 22 February 2016

Newer posts

Older posts