RSS

Category Archives: Database Development

[SQL Snacks Video] The Basics of Joins

[SQL Snacks Video] The Basics of Joins

This is a special edition for SQL Snacks.  It is one (of many hopefully) SQL Snacks that has been recorded with the intention of fulfilling a request by a SQL community member looking to learn more about SQL Server.  It is straight forward, very basic, beginner level information about Joins with a few examples.

 

Tags: , , ,

SQL Saturday #277 Richmond – Covering new ground

SQL Saturday #277 Richmond – Covering new ground

SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and I hope for the same thing in Richmond.  This is my first time to attend a SQL Saturday in a city outside my area of residency, and I will also be speaking there.  This is a bit of a new journey and one that I think I will enjoy.

This is a new experience and one that I have been excited about since speaking with Wayne Sheffield about it at the DC SQL Saturday in December 2013. I have him to thank for encouraging me to spread my wings and I hope for a smooth ride upward from here.  That is the embodiment of the Professional Association for SQL Server (PASS) after all; to establish life long learning and grow the community by giving back.  I think I could probably do a commercial for them or be a PASS spokesperson.  Seriously though, I’ve learned so many things that have helped my career for free or a very low cost.

For this SQL Saturday, I’m also planning to attend the PreCon event scheduled for the day before.  There is still time to register by going to the main site for the event here. I’ve selected to go to session by Robert Davis for my PreCon and it was a hard choice because the “Murder Thy Wrote” PreCon was very appealing as well and I hope to catch that one at the next SQL Saturday I attend.

Read the rest of this entry »

 

Tags: , , , , ,

Why SQL Server Professionals should love Windows 8

Why SQL Server Professionals should love Windows 8

Alright, I’ve got your attention. You’re probably thinking “who is this crazy guy that is using the word Love with Windows 8 in the same sentence?” Honestly though, I have not had many problems with Windows 8 and I’ve been happy running it for a long time. I’m actually disappointed that I don’t have Windows 8 at my job, so I can only use it at home. It has been extremely beneficial for me for my SQL Server related work. Why? And why am I stalling to answer your question? And why am I going to change the subject to Hyper-V?

If you’re still reading, then great, you’ve got the patience for what is coming next. Windows 8 Pro includes a Hyper Visor in it (Hyper-V to be exact).  I’m not talking about software to connect to virtual environments, I’m talking about an actual Hyper Visor that allows you to create and manage virtual machines.  Once you enable the option you’re ready to go after a restart, it’s that simple.

So what does this have to do with me as a SQL Server Professional? Well, how else are you going to build your own lab environment at home or at work where you can play around, build and break things, and be your own domain admin (warning: power may go to your head on that last one). It’s all part of your life long learning journey and your drive to become a better SQL Server Professional and get the latest and greatest version on your machine to test out without ruining your OS. It so happens that I’m a nice guy, and I’ll show you how to get your environment setup and how to create “templates” for future VMs with this Hyper-V Tricks for the SQL Professional Video I put together.

Are you ready to push SQL Server to it’s limits, test things you’ve never tested before, build and break environments without losing your job? If the answer is yes then this video is for you! When you’re done with this video make sure you check out my Virtual SQL Server Lab with Clustering post to enhance your own Virtual playground.

PowerShell Scripts mentioned in video (Remember to rename your VM if you like and to change the paths to match your setup):

new-vm -Name “SQLPS” -MemoryStartupBytes 2048MB -Path R:\HyperV\

new-vhd -ParentPath “R:\HyperV\SQL 2012 Template\SQL2012 Template Drive.vhdx” -Path R:\HyperV\SQLPS\SQLPS.vhdx -Differencing

Add-VMHardDiskDrive -VMName SQLPS -Path “R:\HyperV\SQLPS\SQLPS.vhdx”

 

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

Only one month left! Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount

Only one month left! Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount

The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those who register using the discount code on my website.

The Agenda includes many great topics of interest for both Developers and DBAs:

SQL Server Administration & Maintenance
SQL Server Performance Tuning and Optimization
SQL Server Features & Components
SQL Server Tools, Tricks, and Techniques
BI, Big Data and Data Visualization
SQL Server for the Developer
SQL Server in the Cloud

Read the rest of this entry »

 

Tags:

Slides for SQL Server Internals Presentation with PASS DC Chapter

Slides for SQL Server Internals Presentation with PASS DC Chapter

For those of you that attended yesterday and are interested in the slides, you can download them here.

Thanks!
Topic:
SQL Server Internals Party: Storage, Memory and the Query Life-cycle

Abstract:
Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB & BI Developers and System Administrators. Party hats not included, rated G for Geeks.

 

Tags: ,

SQL Server Internals Presentation with PASS DC Chapter October 10, 2013

SQL Server Internals Presentation with PASS DC Chapter October 10, 2013

If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join me for my presentation on SQL Server Internals. The date is Thursday October 10, 2013 at 6:30PM at the Microsoft Building in Chevy Chase. For more details please visit http://passdc.sqlpass.org/
Topic:
SQL Server Internals Party: Storage, Memory and the Query Life-cycle

Abstract:
Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB & BI Developers and System Administrators. Party hats not included, rated G for Geeks.

Date/Time: October 10, 2013 @ 6:30PM

Location:
Microsoft Technology Center
5404 Wisconsin Ave. Ste. 700
Chevy Chase, MD 20815

 

Tags: ,

Free Conference Pass to SQL Server Live! in Orlando

Free Conference Pass to SQL Server Live! in Orlando

Want a free pass to the SQL Server Live! conference in Orlando this year? Look no further, here is your chance to win a free pass to the conference. Of course, you first have to answer a few questions to be considered!

Read the rest of this entry »

 

Tags:

 
%d bloggers like this: