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

Archives: July 2014

CTE - Limitations

Hi


Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if else statement . This is something basic as the definition of cte that it must be followed by a select, insert, update or delete statement.

That is we cannot…

Read more

0 comments, 1,037 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 27 July 2014

Bug In ado.net enumerator in foreach loop in SSIS 2012

Hi Greetings to everyone,


Today I am going to report a bug in SSIS 2012. In one of the packages I was using execute sql task and then using ado.net foreach loop enumerator. My execute sql task had a simple select statement like - 'select c1,c2,c3 from table' where c1,c2,c3…

Read more

0 comments, 707 reads

Posted in EVERYDAY MSBI/SQL CHALLENGES on 27 July 2014

Lost Administrator SA password SQL server 2012

There are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server is new to you and no idea that has own and access to it. In my case the second option J

In my opinion, it’s very easy to work on… Read more

10 comments, 10,801 reads

Posted in SQL Server Blog Forum on 27 July 2014

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 645 reads

Posted in MSSQLFUN on 27 July 2014

SQLSaturday Porto Edition 2014 Selection Process Results & Voting

This blog post is a continuation of the initial announcement almost a month ago about the session selection process that we decided to do for SQLSaturday Portugal Oporto 2014 Edition, that I have initially blogged about at SQLSaturday Porto edition 2014 Session Selection Process explained

A lot of work, SQLBits… Read more

0 comments, 84 reads

Posted in Niko's blog on 25 July 2014

SQLBits XII Recap

There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.
There is a technological event that is called SQLBits. It’s 12th edition last weekend was a different one.
For me it was the best event ever, technical or non-technical ones including.

Why? Read more

0 comments, 87 reads

Posted in Niko's blog on 25 July 2014

Webinar Q&A: Getting Started with Change Data Capture

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone that attended. If you were unable… Read more

1 comments, 1,213 reads

Posted in Bradley Schacht on 25 July 2014

Speaking on ETL Security

I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.

Securing the ETL Pipeline

We’re going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. Our goal in this isn’t… Read more

0 comments, 713 reads

Posted in Databases – Infrastructure – Security on 25 July 2014

Reblog: July 18 to July 24

Photo credit – Husso

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more

0 comments, 638 reads

Posted in StrateSQL on 25 July 2014

A Question From The NomCom

One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign events should be. I asked on Twitter yesterday and got some good comments, still looking for more. Last year was (I think) the first year PASS hosted live events, one… Read more

0 comments, 573 reads

Posted in SQLAndy on 25 July 2014

Friday Followup For July 25, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Which One’s Better?
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 304 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 July 2014

Thank You SQLBits!

Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party entertainers, long suffering partners and anyone else involved with the event as it was a top, top few days.

This was my 3rd SQLBits after Liverpool + Nottingham and in… Read more

0 comments, 527 reads

Posted in SQL Server Rocks! on 25 July 2014

Thank You SQLBits!

Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party entertainers, long suffering partners and anyone else involved with the event as it was a top, top few days.

This was my 3rd SQLBits after Liverpool + Nottingham and in… Read more

0 comments, 26 reads

Posted in SQL Server Rocks! on 25 July 2014

Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)

Continuation from the previous 34 parts, starting from http://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/

This blog post is about controlling some of the Columnstore Indexes behaviours in less obvious ways – by using Trace Flags & Query Optimiser Rules.
I will be looking into updating this page in the future as the features will… Read more

0 comments, 157 reads

Posted in Niko's blog on 24 July 2014

Power View report migration from SharePoint 2010 to 2013

With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file (starting from Excel 2013) perhaps there will be no big need to migrate old stand alone Power View reports which were based on Power Pivot data models created in Excel…

Read more

0 comments, 7,970 reads

Posted in Data Adventures on 24 July 2014

SQL PASS Performance Palooza 2014 Wrap-Up

Today I presented a fun session for the SQL PASS Performance Virtual Chapter’sSummer Performance Palooza 2014” entitled “Infrastructure Tuning for SQL Server”.

Abstract: Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath… Read more

0 comments, 401 reads

Posted in Technobabble by Klee from @kleegeek on 24 July 2014

How To Get The Boss To Pay For Training

How do you get the boss to pay for training? In my experience you have to:

  • Ask. The boss isn’t sitting around thinking of ways to make your life better
  • Align. Ask for training that is relevant, or show how it is relevant if not obvious
  • Persist. Even if you…

Read more

0 comments, 8,259 reads

Posted in SQLAndy on 24 July 2014

Quick Tips–SQL Prompt Custom Aliases

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

0 comments, 7,829 reads

Posted in The Voice of the DBA on 24 July 2014

My Visit to WPC 2014

Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC stands for “Worldwide Partner Conference”, and this is exactly what it is. Last week it was held in Washington D.C, and there were 16,000 people in this event from over… Read more

0 comments, 372 reads

Posted in Guy Glantser on 24 July 2014

Building the SQLSaturday Orlando Marketing Plan-Part 25

Just the chart today. We’re considerably ahead of previous year registrations for the same number of weeks out. I’m looking at that number every day now!

 

Read more

0 comments, 395 reads

Posted in SQLAndy on 23 July 2014

Newer posts

Older posts