RSS

Tag Archives: sql server

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: ,

Spend some quality time with your Database using Database Snapshots for testing

Spend some quality time with your Database using Database Snapshots for testing

First let’s get things straight, this post is not an encouragement for anyone to spend more time with his/her Database or with Database Snapshots for that matter. If you’re married to your Database, that’s a different story all together and I don’t think I could help you. As database professionals we are always looking to improve the quality of our code and data.  This post is intended to show an easy way to use Database Snapshots in order to  test new code or change data and revert changes back quickly and easily.

Read the rest of this entry »

 

Tags: , , , , , , , , ,

SQL Server Management Studio Rainbow Edition

SQL Server Management Studio Rainbow Edition

Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio?

I have always wondered why all the Databases in management studio were Yellow (Online), Grey (Read-Only), Lighter Yellow with text next to it (something like Restoring), or Yellow with a Red Icon (Offline). Have you ever wondered why there aren’t any more useful colors like Red for when a Transaction Log is Full or Purple when your Statistics are Outdated. I have a theory on this that I have entitled “The Theory that you have to actually work to call yourself a DBA.”

colorful databases

Read the rest of this entry »

 

Tags: , , , , , , , ,

How to Avoid a Database “Heart Attack”

How to Avoid a Database “Heart Attack”

For the past couple of months I have been working with Ben Weiss a Digital Marketing Strategist at Infusive Solutions (http://www.infusivesolutions.com/). Our partnership was based on a mutual understanding that there is much needed career growth and guidance among IT Professionals. Since my background is primarily with Database Management Systems I have been helping him with writing articles, guides, and even interview questions for top professionals in the field, all for the purpose of furthering the careers of IT professionals.

Our latest project is a Lessons Learned pamphlet based on several articles I wrote about a year ago after attending open heart surgery (as an observer, not a patient). Here is the link to the final product, I hope you enjoy and benefit from it.

Here is a link to a summary of the project
http://www.infusivesolutions.com/blog/bid/98928/3-Ways-Business-Observation-Catalyzes-SQL-Server-DBA-Job-Growth

 

Tags: , , , , , , , ,

Email Response: SQL Server 2012 Planning and Architecture

Email Response: SQL Server 2012 Planning and Architecture

I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although I don’t know the gentleman personally, he is a SQL Server professional and I felt obliged to help out a fellow colleague in the field. The email is included below and my suggested solutions following it.

Read the rest of this entry »

 

Tags: , , , , , ,

Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS

Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS

A problem I face often is not knowing the size of a new table that I’m creating. I put some basic code together that pulls the column information from INFORMATION_SCHEMA.COLUMNS and with some basic math gets the approximate size of the table based on the estimated number of rows.

Read the rest of this entry »

 

Tags: , , , , ,

 
%d bloggers like this: