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

Latest Blog Posts

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way.

Manual

The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…

Read more

0 comments, 27 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…

Read more

0 comments, 27 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2015

In-Memory OLTP: Part 4 – Native Compilation

This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery

In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored procedures differ from normal stored procedures in that the In-Memory OLTP… Read more

0 comments, 26 reads

Posted in The DBA Who Came In From The Cold on 27 April 2015

Dear Vendor: Keep My Information Secure

Dear vendor:

Dear Vendor: Keep My Information Secure

If you’re reading this, we have done business together, either directly or indirectly. You might be a retail website from which I purchase products or services. You could be a social media empire on which I share blog posts, life events, and… Read more

1 comments, 35 reads

Posted in Tim Mitchell on 27 April 2015

Perspective

It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me… Read more

3 comments, 42 reads

Posted in The SQL Professor on 27 April 2015

The May Blogger Challenge–Continuing On

Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month I plan to continue, and hopefully get a few more people to up their blogging.

Building on April

To make the next step in starting to blog regularly,… Read more

0 comments, 81 reads

Posted in The Voice of the DBA on 27 April 2015

Monday Morning SQL Break – April 27, 2015

It’s been a while since I’ve posted a blog post.  After the new year, I had been trying to decide on a better way to share the Monday and Friday blog posts that I’ve done for the last couple of years.  Of course, analysis paralysis and my lacking php skills… Read more

0 comments, 35 reads

Posted in StrateSQL on 27 April 2015

Upcoming SQL Saturday Precon Sessions

I have two exciting SQL Saturday preconference training sessions coming up in the month of May!

The first is my Virtualization for SQL Server Professionals training session at SQL Saturday Rochester NY on Friday, May 15th.

Session Abstract: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction… Read more

0 comments, 32 reads

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

Benefits for Some, All or Only a Few

As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can read more about it here and here (as well as here).

Let me start with an important note: I am voicing my opinion here as an individual, not an… Read more

12 comments, 41 reads

Posted in The Scary DBA on 27 April 2015

What SQL version is my SSIS package?

When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how everyone thought DTS was much better and did they really have to switch? Over the years I’ve come to appreciate SSIS. It is a very powerful and useful tool that… Read more

0 comments, 33 reads

Posted in SQLStudies on 27 April 2015

The SSIS Object Variable and Multiple Result Sets

In my most recent post in this series, I talked about how to use the SSIS object variable as an ADO recordset as a source in a data flow. By loading the result set of a query into this variable, the contents of the variable can be read by an… Read more

1 comments, 36 reads

Posted in Tim Mitchell on 27 April 2015

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

The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 5 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, 52 reads

Posted in MSSQLFUN on 27 April 2015

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

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

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

0 comments, 49 reads

Posted in MSSQLFUN on 27 April 2015

Cumulative Update – 7 for SQL Server 2014 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

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

0 comments, 68 reads

Posted in MSSQLFUN on 27 April 2015

Speaking at NT Conference 2015 in Slovenia

It is always feels like a great honour to be invited to speak at a big conference, but when this conference is one of the biggest in its respective area and being run for the 20th time – it feels…

Read more

2 comments, 81 reads

Posted in Niko's blog on 26 April 2015

How to send E-mail/E-mail with Attachments in SQL Server TIP #97

 

In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER.

Sometimes we need to send mail for different requirements like

1) Notification mails like  data inserted /updated/deleted successfully

2)Send data reports like no of amount earned,… Read more

0 comments, 25 reads

Posted in Rajat Jaiswal-337252 on 26 April 2015

Microsoft DataZen Mobile Platform Available to Enterprise Customers for Free

Last week Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite.  This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio.  What’s more, is that they plan to make if free…

Read more

1 comments, 82 reads

Posted in SQL Server BI Blog on 26 April 2015

Hi Folks,


Hope you all are doing good. Would like to start with praying for all those who have been affected by a deadly earthquake in Nepal. Just when it seems that life is good something like this happens, to remind us of that we are not permanent here. Death…

Read more

0 comments, 0 reads

Posted in Everyday IT Challenges on 26 April 2015

Sql Saturday Talk

I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone who came along to my session - I really enjoyed it and I hope you did to.

The slides are available:

Read more

0 comments, 110 reads

Posted in Ed Elliott's Sql Developer Blog on 25 April 2015

SQLPort in Coimbra

One more project can be finally revealed – on the 5th of May of 2015, SQLPort is invading the home base of the 10th eldest university in europe (Unesco World Heritage Site) – Coimbra. This will be an epic 66th…

Read more

0 comments, 124 reads

Posted in Niko's blog on 24 April 2015

Older posts