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

Archives: June 2013

This Can Be the Best Thing in SQL Server 2014

New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most.

I already wrote in the past about the small changes that make a difference in SQL Server 2012, and yesterday about the maturity of SQL Server 2014 Read more

4 comments, 718 reads

Posted in Matan Yungman on 26 June 2013

Natural Born Killers (The series) – Day 7 Table Variables vs Temp Tables

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL Server blog title and to be fair it is.

Those who do know me, will know that I have been presenting a session this year titled “Natural Born Killers, performance… Read more

0 comments, 1,708 reads

Posted in Richard Douglas on 26 June 2013

Non-Clustered Indexes on Table Variables in SQL Server 2014

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Earlier today I have seen a Tweet from Paul White, where he tweeted that SQL Server 2014 supports Non-Unique Clustered and Non-Clustered Indexes for Table Variables in SQL Server 2014. So… Read more

0 comments, 1,587 reads

Posted in Klaus Aschenbrenner on 26 June 2013

SQL Server 2014 CTP1 Now Available!

Sweet! SQL Server 2014 CTP1 is now available for download at Microsoft.com! Get it while it is hot, and start your evaluations. You can also download the product guide here so you can know exactly what has changed and what new features matter the most to you!

The most… Read more

0 comments, 282 reads

Posted in Technobabble by Klee from @kleegeek on 26 June 2013

Terminate a SSIS package after specific time interval.



 

There are several ways you can execute scheduled SSIS package/job they are:
 

A)     SQL Server Agent Job.
B)       Windows Schedule Task.
C)      Third party program, like SQL Sentry
 

Nirav's Diary has example on using…

Read more

1 comments, 1,054 reads

Posted in SQL Development Wizard on 25 June 2013

Installing SQL Server 2014 CTP1 – Step by Step

Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your fresh copy from here.

Here is the official announcement with some high level details.

In this post we will do a quick step by step walk through… Read more

6 comments, 1,144 reads

Posted in SQLSailor.com on 25 June 2013

VMware vSphere Storage Performance - Thick vs Thin Provisioning

Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make it cheaper and easier to manage.  The task of most VM administrators is to cram as many VMs into a farm as possible.  One of the ways is to accomplish…

Read more

0 comments, 801 reads

Posted in Everyday SQL on 25 June 2013

SQL Server: Part1 : All About SQL Server Statistics :Density Vector

In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer  use the statistics to choose the right query plan. if the statistics are wrong or outdated , SQL server might choose a wrong query plan. In this post, let us try…

Read more

1 comments, 624 reads

Posted in PracticalSQLDba on 25 June 2013

My Thoughts about SQL Server 2014

SQL Server 2014 is coming. Go ahead and download the public CTP.

I’ve just started getting my hands dirty with the new version. Based on that and on the stuff that has already been published, here’s a few thoughts:

SQL Server 2014 is Mature

Microsoft takes care of… Read more

1 comments, 2,243 reads

Posted in Matan Yungman on 25 June 2013

SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 3

4. Setup 2 nodes alwayson availability group 
    a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"

    b) Restore database "MYHA" to secondary server "SQL2012-02"
Backup-SqlDatabase -Database "MYHA" -ServerInstance "SQL2012-01" -BackupAction Database -CompressionOption On -backupfile "\\WIN-JIASUMAU0DF\Backup\MYHA_FULL.bak"

Restore-SqlDatabase -Database MYHA -ServerInstance sql2012-02 -BackupFile "\\WIN-JIASUMAU0DF\Backup\MYHA_FULL.bak"…

Read more

0 comments, 577 reads

Posted in James' SQL Footprint on 25 June 2013

SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 2

3. Install SQL Instance
   a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=TCP localport=1433 profile=DOMAIN

echo Dedicated Admin Connection
netsh advfirewall firewall add rule name="SQL DAC" dir=in action=allow protocol=TCP localport=1434 profile=DOMAIN

echo SQL Browser Service 
netsh advfirewall…

Read more

0 comments, 676 reads

Posted in James' SQL Footprint on 25 June 2013

Exploring Excel 2013 for BI Tip #9: Adding Calculated Members

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 695 reads

Posted in DataOnWheels on 25 June 2013

SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 1

Here are some scripts which can be used for setting up 2 nodes AlwaysOn Availability Groups, you can make your own automation script based on them.

Environment :
Name IP Address OS Description
SQL2012-01 192.168.1.21 Win2012 Primary
SQL2012-02 192.168.1.31 Win2012 Secondary
SQL2012HA 192.168.1.41 N/A AG Listener
SQLClUSTER 192.168.1.50 N/A Cluster Name

Read more

0 comments, 1,127 reads

Posted in James' SQL Footprint on 25 June 2013

First steps with Extreme Transaction Processing – Hekaton

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

A few hours ago Microsoft released the first public CTP of SQL Server 2014. The download and the installation went very smooth, the only new restriction is that you are not… Read more

0 comments, 2,109 reads

Posted in Klaus Aschenbrenner on 25 June 2013

SQl Server 2014 CTP1

CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can go grab it now! If you are curious about some of the features here is the Microsoft page and there are plenty of blogs out there as well: http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

This… Read more

0 comments, 241 reads

Posted in Bradley Schacht on 25 June 2013

The Secret to Keeping Your Cool Like an Experienced Production DBA

Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.

Things can and will go wrong in your environments. Even the greatest software contains bugs and hardware fails, often.

When an unforeseen issue arises your reaction can directly influence… Read more

2 comments, 2,013 reads

Posted in John Sansom - SQL Server DBA in the UK on 25 June 2013

Natural Born Killers (The series) – Day 6 Sargability

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL Server blog title and to be fair it is. Those who do know me, will know that I have been presenting a session this year titled “Natural Born Killers, performance… Read more

0 comments, 1,845 reads

Posted in Richard Douglas on 25 June 2013

SQL Server 2014 CTP1 Released

It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded it and it weighs in at about 3.5gb... I'm supposed to be revising for an upcoming exam, but that will have to go on hold now for a few days… Read more

0 comments, 277 reads

Posted in SQL Server Rocks! on 25 June 2013

NYC SQL User Group Mtg - Building a Personal Brand

This month, Thursday, June 27, 2013, the NYC SQL User Group be doing something a little different. Instead of a technical presentation, we’ll be learning about some very important non-technical skills needed for database professionals to advance their careers. We’ll be meeting on Thursday June 27th at 6:00 PM at our… Read more

0 comments, 431 reads

Posted in Pearl Knows on 25 June 2013

SQL Server 2014 CTP1 is here!

As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server 2014!), the CTP1 was to be released in June, and that time has come.

Download it here, or it is available for download through a MSDN or… Read more

1 comments, 536 reads

Posted in James Serra's Blog on 25 June 2013

Newer posts

Older posts