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

Archives: May 2015

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have a similar need, or want to learn more, I’d urge… Read more

2 comments, 583 reads

Posted in The Voice of the DBA on 27 May 2015

Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)

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

This is a not very deep technical post, which is describing the upcoming news and changes in SQL Server 2016.
Since there is no public CTP (Community Technology Preview), there is no chance (well besides doing… Read more

10 comments, 777 reads

Posted in Niko's blog on 27 May 2015

How an MPP appliance solution can improve your future

Massive parallel processing (MPP) is the future for data warehousing.

So what is MPP?  SQL Server is a Symmetric Multiprocessing (SMP) solution, which essentially means it uses one server.  MPP provides scalability and query performance by running independent servers in parallel.  That is the quick definition.  For more… Read more

4 comments, 624 reads

Posted in James Serra's Blog on 27 May 2015

SQL F.A.D. – CSV List of Columns - WaterOx Consulting

Reading Time: 2 minutes

I had a project once that was using change data capture (CDC)...

The post SQL F.A.D. – CSV List of Columns appeared first on WaterOx Consulting.

Read more

1 comments, 392 reads

Posted in WaterOx SQL on 27 May 2015

PASS Board Update: May 2015

I’ve had a busy month on the Board.

You may have seen some tweets going by about our compliance with international laws regarding SPAM. This has been something of an education, so anything I say wrong below, it’s because I’m wrong, but not malevolent (at least in regards to this… Read more

5 comments, 437 reads

Posted in The Scary DBA on 27 May 2015

High Performance T-SQL using Code Patterns

What exactly does this mean?  We’ve heard of “code patterns” in other programming languages, but what does it mean to use T-SQL code patterns to develop high performance T-SQL?  Having now been called out by a couple of folks in the SQLverse that I respect, most recently the editor of… Read more

6 comments, 7,469 reads

Posted in DwainCSQL on 27 May 2015

Speaking at ITPROceed 2015

This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT professional. The conference takes place the 11th of June at Utopolis Mechelen. My session is situated in the Data Platform & Internet of Things track and is titled Demystifying… Read more

0 comments, 325 reads

Posted in Koen Verbeeck on 27 May 2015

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work…

Read more

7 comments, 358 reads

Posted in SQL Server BI Blog on 27 May 2015

Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work…

Read more

7 comments, 179 reads

Posted in SQL Server BI Blog on 27 May 2015

Native Client Aliases don’t like Trailing Spaces

I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that it deserved a shout out to the community.

When you create an alias in the SQL Server Configuration Manager, make sure that the alias name contains no spaces,… Read more

0 comments, 1,419 reads

Posted in SpaghettiDBA on 26 May 2015

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt from each with a link to the full article: Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform (Part 1) Microsoft Datazen is a new tool from Microsoft built on…

Read more

1 comments, 355 reads

Posted in SQL Server BI Blog on 26 May 2015

New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt from each with a link to the full article: Getting Started with Datazen, Microsoft’s New Mobile Dashboard Platform (Part 1) Microsoft Datazen is a new tool from Microsoft built on…

Read more

1 comments, 148 reads

Posted in SQL Server BI Blog on 26 May 2015

Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP

Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored procedure(With Execute as Owner), and was getting an error –

ERROR:

Could not obtain information about Windows NT group/user ‘Domain\UserName’, error code 0x5.

My first reaction was to… Read more

1 comments, 1,130 reads

Posted in SQLSailor.com on 26 May 2015

Migrating SQL Agent Jobs with Schedules using T-SQL

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like. One thing I have not found readily is the ability to create jobs while maintaining the scheduling in place. For those who may not be aware, the easiest way to… Read more

3 comments, 610 reads

Posted in Jared Zagelbaum's Blog on 26 May 2015

Tuesday Morning SQL Break – May 26, 2015

It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information… Read more

0 comments, 414 reads

Posted in StrateSQL on 26 May 2015

Database Engine Tuning Advisor

I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that I included a chapter on it in my query tuning book (all updated for SQL Server 2014 by the way). Let me tell you why we need to pull… Read more

10 comments, 638 reads

Posted in The Scary DBA on 26 May 2015

SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script

This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for running SQL Server Agent Jobs. Here are the links to the 2 previous posts and I recommend reading them because all of the posts build on the previous one.

Creating… Read more

0 comments, 518 reads

Posted in cjsommer.com on 26 May 2015

Default database

What?
The default database is one of the options when creating a login in SQL Server. This is the initial database that the login will connect to when logging in. Unless of course you specify a different database in your connection string.
 
How?

-- Creating a login with a…

Read more

1 comments, 674 reads

Posted in SQLStudies on 26 May 2015

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite

Once you have created your database you can now start to manage and configure it.

There are six menus for a SQL Azure Database: -

  • Dashboard
  • Monitor
  • Scale
  • Configure
  • GEO-Replication
  • Auditing and Security
The Dashboard

The Dashboard gives an overview of the state of your Azure database.… Read more

0 comments, 603 reads

Posted in The SQL DBA in the UK on 26 May 2015

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can download the datasheet they’ve posted from here.

The features that have caught my attention are:-

  • Enhancements to In-Memory OLTP
  • The Query Data Store
  • Temporal Database
  • Stretch Database
  • Automatic failover…

Read more

0 comments, 1,069 reads

Posted in The DBA Who Came In From The Cold on 26 May 2015

Newer posts

Older posts