RSS

Tag Archives: SQL Server 2012

Free SQL Server 2012 Installation Guide

Free SQL Server 2012 Installation Guide

Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve been mooching off them them for so long. I’ve put together a short Installation Guide for those interested in getting their feet wet with SQL Server. I’m trying to encourage those that have no experience to get a little curious and try to install SQL Server and play with it.  Maybe afterward you can even try to set up your own Clustered SQL Server Virtual Lab with Hyper-V. Just trying to rub off some of the enthusiasm and passion, did it work?

Anyway you can view the guide Here on Google Docs or Download it Here as PDF. It is just a first draft, so please feel free to add your suggestions or point out mistakes and I will try to fix it ASAP.

You can also read it right off of this page… check it out by clicking “Read the rest of this entry”

Read the rest of this entry »

 

Tags: , , ,

SQL Server 2012 Virtual Lab with Clustering using Hyper-V

SQL Server 2012 Virtual Lab with Clustering using Hyper-V

After having a great opportunity to attend a Beta course for Hyper-V with Windows 2012 at Learning Tree, I decided to finally do what I have been planning to do for a while; build a fully working SQL Server Clustered Virtual Lab.

Read the rest of this entry »

 

Tags: , , , , , , , , , ,

SQL Saturday in Washington D.C. December 8, 2012

SQL Saturday in Washington D.C. December 8, 2012

This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near the D.C. Metro area I hope to see you there. If you have not registered, you still have a chance:

http://sqlsaturday.com/173/eventhome.aspx

I’ve put together a short list of the sessions that I am planning to attend with some brief reasons why. Hope to see you all there!

Read the rest of this entry »

 

Tags: , , , , ,

SQL Server Parallel Data Warehouse (PDW) and SQL Server Fast Track Data Warehouse


The SQL Server Parallel Data Warehouse and SQL Server Fast Track Data Warehouse are very high end builds of Microsoft’s SQL Server 2008R2 product; and SQL 2012 in the future. I’ve been intrigued by these products so I’ve started to learn about it. They have both been on the market for a while, but I’ve just recently been exposed to the technology and it has been exciting to learn more and more about it.

James Serra was kind enough to take the time to point me in the right direction with a great post that he wrote up last year:
http://www.jamesserra.com/archive/2011/08/microsoft-sql-server-parallel-data-warehouse-pdw-explained/

Here are some additional resources about this product:
https://www.microsoft.com/sqlserver/en/us/solutions-technologies/data-warehousing/pdw.aspx

http://dwjunkie.wordpress.com/2012/02/22/parallel-data-warehouse-pdw-poc-lessons-learned/

Finally, a very nice set of videos provided by the Microsoft Virtual Academy:

https://www.microsoftvirtualacademy.com/tracks/breakthrough-insights-using-microsoft-sql-server-2012-scalable-data-warehouse

Module 2  talks about the PDW architecture. Module 4 talks about the Fast Track Datawarehouse; which is a product that sits between your custom build of SQL Server and the PDW. Of course all the other modules are useful, but just in case you wanted to take a quick dive into material related to the PDW you should go for Modules 2 and 4.

 

Tags: , , , , , ,

SQL Server 2012 Service Pack 1 available for RTM


SP1 for the RTM of SQL Server 2012 has been announced during PASS Summit 2012.

It can be downloaded here:

http://www.microsoft.com/en-us/download/details.aspx?id=35575

Don’t worry, it’s not for the CTP as I posted a some weeks back 🙂

 
 

Tags: ,

Link

Log File Full–Availability Group Database

An interesting post by Gethyn Ellis about an issue he encountered using Availability Groups. Follow the link above to read more.

I run into an interesting issue with an Availability Group database recently. I was running a data load against a database in an Always On Availability group database in SQL Server 2012.  The load was SSIS package migrating data from staging database when the package fell over with the following error

“The transaction log for database DBName is full due to ‘AVAILABILITY_REPLICA’”

 

Tags: , , ,

SQL Server 2012 Service Pack 1 Released for CTP4.


CORRECTION: This is for CTP4 (Community Technology Preview) not RTM (Release to Manufacturing). Therefore, you cannot install this if you are running a full version of SQL Server 2012. Sorry for the confusion, the original article I read did not mention anything about it being for CTP.

Fresh off the tree and ripe for picking…

Link for downloading SQL Server 2012 CTP4 Service Pack 1:
http://www.microsoft.com/en-us/download/details.aspx?id=34700

 

Tags: , , ,

Point in Time recovery via GUI a new SQL 2012 Feature


Very nice post about one of the new features of SQL 2012 – the GUI for point in time recovery.

Basit's SQL Server Tips

SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases with SQL Server Management Studio. As we know, SQL Server provides a variety of backup types, so creating the proper recovery sequence for each point in time can be tricky at times. This is where Database Recovery Advisor is useful, because it makes the database restoration process more agile by helping the customers to create more predictable and optimal recovery sequence.

The Database Recovery Advisor provides a visual timeline from the backup history of the database and then presents the available points in time at which the user can restore the database, algorithms to streamline the identification of the appropriate sets of backup media to restore the database back to a specific point in time. By default, the Database Recovery Advisor tries to restore the database from the last backup…

View original post 186 more words

 

Tags: ,

Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)

Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)

I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get hands on with SQL Server. I even have Virtual Hard Drives (VHDs) that I can download directly from Microsoft; there are even publicly available ones HERE. My problem is on the hardware end. Since I’m not a millionaire that can throw money around and buy an entirely new server to put Windows Server on with SQL Server, I had to find another way… and I did 🙂

Read the rest of this entry »

 

Tags: , , , , , , , ,

SQLAuthority News – Microsoft Whitepaper – AlwaysOn Solution Guide: Offloading Read-Only Workloads to Secondary Replicas


 

Tags:

Jump start your SQL 2012 Certification for FREE

Jump start your SQL 2012 Certification for FREE

Hey all you proactive SQL junkies, want to jump start your SQL 2012 Certification? Or are you just here because you saw the world’s most favorite four letter word – FREE? Either way I got your fix right here.

Read the rest of this entry »

 

Tags: ,

SQL Server 2012 New Feature – The Sequence Object

SQL Server 2012 New Feature – The Sequence Object

One of the cool new features with SQL 2012 is the Sequence Object.  One of the worst parts of this feature is that whenever I mention it’s a cool new feature a lot of people say “that has been in Oracle forever.” Patience is a virtue!!

Anyway, so I like to consider the Sequence Object as a “Global Identity” that can be shared by many objects in the same database, or even across databases on the same server (I have not tried it via Linked Servers because I only have one test SQL 2012 server). You can take values from the Sequence Object and insert them into tables or you can have a column in a table default to a value from the Sequence Object. A warning to the wise: If you assign a default value for the table as a Sequence Object then you cannot drop it because of dependencies. That is actually a pretty good security measure.

I have included a code snippet so that you can play around with this new feature and I’ve put a few screen shots to show how you can manage it via the GUI. Make sure you run the code section by section; I have included a lot of comments to let you know what to expect while running it.

Read the rest of this entry »

 

Tags: , , ,

Deploying a SQL Server 2012 Multi-Subnet Cluster


Excellent write up on how to deploy a SQL Server 2012 Multi-SubNet Cluster (GeoCluster).

- Microsoft technologies and what I do for fun -

I’ve been wanting to write a series of articles on deploying a SQL Server 2012 on a multi-subnet cluster for quite some time now. This was driven by the fact that my series of articles on SQL Server 2008 Failover Clustering had been in the Top 10 Tips for more than 2 years since being published three years ago. I guess more and more systems administrators and SQL Server DBAs are being tasked with deploying failover cluster instances. Ever since I had my hands on the beta version of Denali (codename for SQL Server 2012) last year,  I’ve been testing some configurations for the multi-subnet clustering feature. I think I’ve built like 3 test environments prior to Denali going RTM just so I can wrap my head around the concepts (plus the fact that Windows Clustering Experts like Microsoft MVP Allan Hirt (blog | Twitter) have been gracious…

View original post 107 more words

 

Tags: , ,

SQL Security Architecture Decomposed Presentation

SQL Security Architecture Decomposed Presentation

Professional Association for SQL Server Presentation
Topic: SQL Server Security Architecture Decomposed
Presenter: Ayman El-Ghazali

Abstract: Security can be difficult to understand when first approaching SQL Server due to the many layers. In this webinar we will take a top down look at SQL Server Security and then “peel” its layers one by one to understand how it works. This webinar will help those who wish to understand security layers and concepts better with in SQL Server. We will cover how to properly manage individual and group access to your SQL Instance, Databases, and many other securables. Please join us on this journey from your server’s network port all the way to your tables, stored procedures, and functions.

http://dba.sqlpass.org/MeetingArchive.aspx

June 27, 2012 – SQL Server Security Architecture Decomposed. Click here to start streaming.

Slides and Code for all Presentations can be found here

 

Tags: , , , , ,

SQL Server 2012 New Features Presentation

SQL Server 2012 New Features Presentation

Professional Association for SQL Server Presentation
Topic: SQL Server 2012 New Features
Presenter: Ayman El-Ghazali

SQL Server Presentations with PASS (Professional Association for SQL Server) Virtual DBA Chapter.

http://dba.sqlpass.org/MeetingArchive.aspx

January 11, 2012 – SQL 2012 New Features. Click here to start streaming.

Slides and Code for all Presentations can be found here

 

Tags: , , , ,

 
%d bloggers like this: