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

Archives: April 2015

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the "MAIN" proc which… Read more

0 comments, 1,179 reads

Posted in SQL Barbarian on 30 April 2015

Excel BI Tip #26: Using a Data Spreadsheet or Tab

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 845 reads

Posted in DataOnWheels on 30 April 2015

SQL Saturday 392 – Atlanta, GA

Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May 16th, there at SQL Saturday #392.  This will be my first time presenting at their SQL Saturday and I’m really looking forward this great event. According to… Read more

0 comments, 603 reads

Posted in John Morehouse | Sqlrus.com on 30 April 2015

Elite VMware SQL Server Workshop Wrapup

This past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware. The first workshop, held last year, was a tremendous success and we all wanted to keep the momentum going with more SQL Server gurus. Over the last few months,… Read more

0 comments, 733 reads

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

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace…

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of columns and a view name, and it would generate a select statement from this view. Due to requirements at the time, I needed the flexibility of the “MAIN” proc which… Read more

0 comments, 461 reads

Posted in SQL Barbarian on 30 April 2015

Spinach and Database Development- SQLSatExeter Keynote

Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we were delighted to have a world exclusive keynote video by Phil Factor about Spinach and Database Development. With many thanks to those that made it possible and particularly to Phil… Read more

2 comments, 690 reads

Posted in SQL DBA With A Beard on 30 April 2015

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database
MAY 1, 2015

In my last post, I discussed some of the concepts around Sharding and how we could use Sharding and Azure Database Elastic Scale in a real world application to implement Horizontal Scaling. In…

Read more

0 comments, 2,623 reads

Posted in Pie in the Sky on 30 April 2015

Know About .MDF and .NDF In SQL Server

In SQL Server Records (Data) and log information is not stored in one file. There are three types of individual files used by SQL server to store its information. These files are Primary data file and secondary data file. These two individual files are used by one SQL server. These… Read more

2 comments, 9,562 reads

Posted in Zora's SQL Tips on 30 April 2015

Altering a column to add NOT NULL

I had to do this recently and needed to look up the syntax as I couldn’t remember it. I don’t do this often, but I was working on a particular item and wanted to test this.

I had a table, something like this:

CREATE TABLE SimpleTable ( MyID INT NOT

Read more

2 comments, 1,018 reads

Posted in The Voice of the DBA on 29 April 2015

They Can Do What? – SHUTDOWN - WaterOx Consulting

Reading Time: 1 minutes

Many times the DBA is faced with the dilemma of granting excessive...

The post They Can Do What? – SHUTDOWN appeared first on WaterOx Consulting.

Read more

3 comments, 669 reads

Posted in WaterOx SQL on 29 April 2015

Running Powershell scripts remotely.

I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of tasks it can perform. Currently I’m working on a task to run SSIS packages remotely by using Invoke-Command to run DTEXEC on a remote machine. I’ll be posting the final… Read more

2 comments, 1,137 reads

Posted in SQLStudies on 29 April 2015

Better Together: Reduced Run Time and I/O

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one management cares about.  When DBAs have the task of cutting down the run time of a query, this typically starts in a non production environment, consisting of different server architecture… Read more

0 comments, 671 reads

Posted in Adam Kreul | Blog on 29 April 2015

DataZen Dashboards Update

I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think this is going to be significant addition to the enterprise BI offering. It’s not quick and easy to setup the server, configure data sources, data view queries and design dashboards…

Read more

14 comments, 1,028 reads

Posted in SQL Server BI Blog on 29 April 2015

DataZen Dashboards Update

I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think this is going to be significant addition to the enterprise BI offering. It’s not quick and easy to setup the server, configure data sources, data view queries and design dashboards…

Read more

14 comments, 352 reads

Posted in SQL Server BI Blog on 29 April 2015

Outlier Detection with SQL Server, part 6.2: Finding Outliers Visually with Reporting Services Box Plots

 By Steve Bolton

…………Throughout this series of amateur mistutorials in using SQL Server to identify outliers, we have repeatedly seen that the existing tried-and-true methods of detection long used for such purposes as hypothesis testing are actually poorly suited for finding aberrant values in large databases. The same problem… Read more

0 comments, 1,193 reads

Posted in Multidimensional Mayhem on 29 April 2015

MySQL TinyInt treated as Boolean

When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the issues are related with handling of certain data types such as “TinyInt”.

A particular issue I recently came upon was the fact that TinyInt(1) is treated by default… Read more

0 comments, 929 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 29 April 2015

Excel in T-SQL Part 1 – HARMEAN, GEOMEAN and FREQUENCY

Today’s blog will be the first in a multi-part series on replicating Excel functions in T-SQL, starting with HARMEAN, GEOMEAN and FREQUENCY.

We’ll focus our solutions on creating T-SQL in-line, Table Valued Functions (iTVFs), introduced in SQL Server 2005, that apply the solution technique to a specifically designed… Read more

1 comments, 1,360 reads

Posted in DwainCSQL on 29 April 2015

Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller

This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.


In Part I of this series, I showed you how to setup the networking and router for our simulated network. In this article,… Read more

1 comments, 1,578 reads

Posted in The Data Files on 29 April 2015

Using SSIS Lookup Transformation in ETL Packages

Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of two datasets: input columns from a data source and columns in a reference dataset – a table, view or a result of a query. Lookup can be used in… Read more

2 comments, 8,229 reads

Posted in Gorandalf's SQL Blog on 29 April 2015

Older posts