Thank you for visiting New London SSUG blog. 

Here you will be able to read everything about Microsoft SQL Server and PASS.  Blog is open for submission to every member of New London SSUG.

 

 

 

 

  PASS Blog 

Monitor SQL Server AlwaysOn Availability Groups by Ben Snaidero - Wednesday, January 4, 2012

 

Monitor SQL Server AlwaysOn Availability Groups 
by 
Ben Snaidero

The new AlwaysOn Availability Groups feature of SQL Server 2012 (Denali) provides DBAs with another option for high availability, disaster recovery or offloading reporting. This tip will look at how we can monitor (SQL Server Management Studio, T-SQL, DMVs and System Monitor counters) and make sure AlwaysOn is functioning as expected once properly configured (see Part 1 or Part 2 for how to setup SQL Server AlwaysOn).  More 


 
Alias issue in T-SQL or defensive programming - Monday, January 2, 2012

 

 

Blog Posts by Uri Dimant

 

 • Blog Post ♦ Alias issue in T-SQL or defensive programming

 • Blog Post ♦ Desling with duplicates 

 • Blog Post ♦ Be careful to grant dbCreator server role to the user

 

 

 

Jorge Segarra

SQL Server MVP,Co-authored the book from Apress “
Pro SQL Server 2008 Policy-Based Management“.
Twitter
Email:jorge@sqlchicken.com


Policy Based Management in a Nutshell.
More 
 

 

The Rambling DBA: Jonathan Kehayias

Principal Consultant for SQLskills.com, SQL Server MCM and MVP, Rambling DBA.
@SQLPoolBoy 


Making Use of Plan Explorer in my own Environment

Back in October 2010, I briefly blogged about the 
SQL Sentry Plan Explorer in my blog post wrap up for SQL Bits 7 and how impressed I was with what I saw from a Alpha demo standpoint from Greg Gonzalez (Blog|Twitter) while I was at SQLBits 7 in York.  To be 100% honest and transparent, Greg gave me early access to this tool after discussing it at SQLBits 7, and I had the opportunity to test a number of pre-Beta releases where I was able to offer significant feedback and submit bugs in the tool to Greg and the primary developer of the tool with SQL Sentry before Greg ever announced the public beta of the tool on his blog. More


 

 

   10/27/2011

 

PASS 2011 in Seattle, WA.
                For the past several years, I have heard many SQL professionals of different levels attending PASS, however, this year’s summit was my first. It was an excellent experience and this year summit reached 5000 + Microsoft Professionals from all over the world.  
This conference was perfectly planned and presented by the SQL Server community, for the SQL Server community.  PASS Members and PASS Volunteers conducted an  unbelievable work. PASS volunteers helped everybody reach their scheduled classes on time regarding of how arduous the task might seem. There were many exiting classes to attend but the time was limited.  There are over 200 sessions in three days, so as a SQL professional, you will need to plan your time accordingly. Sessions are scheduled in different rooms on various floors, so navigating between classes can get a little tricky – especially if this is your first time attending.
Lunch with your Chapter Leader and MVP was very good idea. This helped people to discuss some SQL Server issues and present questions to MVP and Speakers. Another smart idea and good organization from PASS team.
The list of vendors who presented their products was very impressive. Quest, Idera, Dell and Microsoft were just a few of them. It was interesting and informing to sit through their presentations and learn a thing or two. It was very helpful to spend time in Microsoft Lab and get hands on experience in new options and immediate answers from Microsoft Professionals.
 
            I would definately recommend any DBA to make time and seriously consider attending PASS Summits. Attending classes and connecting with Microsoft MVP’s is a necessary experience and should not be taken for granted. PASS Summit remains a best place to meet SQL professionals, meet new friends and obtain new contacts.  Cannot wait for PASS 2012.
 
 
 

 

 

     11 /05 /2011

 

 

Create New Database and Tables


 

A database is nothing else but a collection of data.
A database could be as simple as a text file with a list of addresses, emails, names and data of that sort. It could also be as complex as a large, relational database management system (RDMS), with built in tools to help you maintain your data.
Before I will get into database management systems, let me start with the basics - let's look at a simple text file example.

 
We could use this information to do things such as send an email to everyone on our list. We could do this because, this file was created in the way, that we know that each row contains a different individual. Also, the items in each row are separated by commas. Therefore, we know that the email address next to "JRobinson" is her email address. Each row in this example can also can be called a record. Therefore, we currently have 3 records in our database.
Database Management System (DBMS), is a software program that enables the creation and management of databases. Most of today's database systems are referred to as a Relational Database Management System (RDBMS), because of their ability to storerelated data across multiple tables.
Some of the more popular relational database management systems include:
  • Oracle
  • Microsoft SQL Server
  • MySQL
  • Microsoft Access
 
This tutorial will allow you to become more familiar with some of the key concepts of database management systems such as:
  • Database creation
  • Tables and Tables Creation
  • Adding data to your database
  • Querying a database
  • Relational database design
·         Microsoft SQL Server

 
·         Microsoft SQL Server is a robust database management system. SQL Server is more suited for enterprise applications such as corporate CRMs and websites etc.
 
·         The above screen is what you see when you open SQL Server through the Enterprise Manager. Enterprise Manager is a built-in tool for managing Microsoft SQL Server and its databases. In this example, there are 2 databases. Each database is represented down the left pane, and also in the main pane (with a "database" icon).
.
·         Many database administrators (DBAs) use Structured Query Language (SQL) to perform many of their database tasks. To enter SQL, you need to open an interface that allows you to enter your code. For example, if you use SQL Server, you would normally use Query Analyzer. 


·         The following example is the basic code for creating a new database. Parameters can be added to this example if your requirements are more specific.
          Example #1 Creating database using TSQL

 
Example #2 Creating database using GUI
 
·         Most database systems make it very easy to create a database via a user interface. Generally, it's just a matter of selecting an option from a menu, then providing a name for your database.

Newly created database is blank because it doesn't have any user tables. The only tables you would see in your new database are the system tables. In database terms, a table is responsible for storing data in the database. Database tables consist of rowsand columns.
So let’s create a new table.
Open Management Studio and expand “DATABASES” then expand “TABLES”
 
Now let’s “Right Click on TABLES” and select “NEW TABLES”

Now let’s create same table as we created as a text file previously.

Now if you will refresh your view you will be able to see newly created table.
 
Let’s re-cap what we have done so far. We created Database called “TEST”, we created table called “Employee”
Now let’s fill this table with some information.   This can be done using GUI or TSQL.
Example #1 Filling table Employee using GUI:
Right click on a table and choose “EDIT TOP 200 ROW”, you should see screen similar to the one below:

After filling in information your table should look like as example below:

Click “SAVE” Button and close this screen.
Now you have records in your table. Another way to fill in this table is to use a TSQL Code.
Let’s try to add couple more records to this table using TSQL.
Open Query Analyzer and type following:

Now we have records in our table inserted using two different ways.
Let’s check to make sure we have 5 records in our table.

This tutorial showed you how to user TSQL and GUI in Microsoft SQL Server to create Database, Create Table and fill this table with data.
In my next tutorial, I will show you how to use Microsoft SQL Server to build Relational Database using Multiple tables and how to related those tables between each other.
 
 
 

 

 TitleOwnerCategoryModified DateSize 
Installing and configuring Microsoft Reporting ServicesVictor Pavlov 11/19/20111.17 MBDownload