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

Archives: May 2011

ACID Rules in Sql Server


ACID Rules

ACID Rules:- It is a concept for evaluation of databases and their architecture.

A:- (Atomicity) – Atomicity  states the principle of  All or none. This means that either all the SQL Statements within the transaction will be executed or no Sql statement will be executed.

C:- Consistency:- Consistency…

Read more

0 comments, 1,522 reads

Posted in Vivek's SQL Notes on 28 May 2011

DML, DDL, DCL, TCL in SQL Server


Different Types of Sql Statements:-

DML
DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.

Examples: SELECT, UPDATE, INSERT statements

Select :- This Sql Statement is used to extract the data from one or combination of tables

Read more

0 comments, 3,958 reads

Posted in Vivek's SQL Notes on 28 May 2011

Restoring a database from higher version to lower version SQL server

Restoring a database from higher version to lower version SQL server

How to downgrade a database from higher version to lower version?

There is no direct way to do this like Backup/Restore. You can use an alternative ways.

The alternative ways are,

 

1. Generate Script

2. Import/Export

3. Transaction…

Read more

12 comments, 1,044 reads

Posted in SQL Server Blog Forum on 28 May 2011

Accidentally Dropped the Distribution Database

Have you made the mistake of dropping your distribution database like this?

If so, remember not to do this ever again.  Disabling publishing and distribution involves more than just dropping the distribution database.  The distribution database in SQL Server requires special attention and dropping it in this fashion can wreak… Read more

0 comments, 976 reads

Posted in SQLREPL on 28 May 2011

Using Views for Faster SQL Query Development

A discussion of how views give a more denormalized means for querying against normalized tables.

Ad-hoc reports are frequently requested at the Boston Public Schools. Generally each request is different but similar to ones previously made. To the degree that such requests are unique, there’ll always be work involved in… Read more

1 comments, 417 reads

Posted in Help With SQL on 28 May 2011

SQL University Troubleshooting Week: Having a Plan for Every Situation

Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals may encounter in the course of our day. We will start off by looking at why we need to have a plan for every situation, and then we will dig… Read more

0 comments, 375 reads

Posted in Adventures in SQL on 27 May 2011

Search Active Directory (AD) from your desktop

Ever see a Windows group and want to know all the users in that group without having to ask your system admin?  There is an easy way to do this.  Just create this shortcut on your desktop:

%SystemRoot%\SYSTEM32\rundll32.exe dsquery,OpenQueryWindow

Call it something like “Search AD”.  Then when you run it… Read more

0 comments, 285 reads

Posted in James Serra's Blog on 27 May 2011

Re-blog – May 20-26

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts of interest that you may want to check out are:

Read more

0 comments, 215 reads

Posted in StrateSQL on 27 May 2011

MCITP: 2 Down 2 to go

It’s time for the weekly update.  Much like last week, we had more issues with taking this exam today.  I scheduled exam 70-433 for first thing in the morning at a “private” test center.  The registration was easy enough.  The process is a bit different since this test center… Read more

0 comments, 229 reads

Posted in SQL RNNR on 26 May 2011

SQL Server, Storage and You Part 2!

I saw 500 faces an rocked them all!

To those who attended my webinar today THANK YOU! If you didn’t…. There is a third one coming on solid state! As always the slide deck is posted here. I’ll be adding this information and some additional details to my ongoing… Read more

0 comments, 313 reads

Posted in SQL Man of Mystery on 26 May 2011

SQL University Troubleshooting Week: Keeping an Open Mind

Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem rather than being seen as a part of it. We may have the best intentions and know our systems inside and out but if we refuse to look into something… Read more

0 comments, 378 reads

Posted in Adventures in SQL on 26 May 2011

SQLRally 2011 Women in Technology Luncheon

On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon!  I moderated, and our esteemed panel was made up of

Read more

1 comments, 373 reads

Posted in SQL Awesomesauce on 26 May 2011

Endpoints Need Privileges Too

Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment.

Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been using VM Workstation for my… Read more

0 comments, 603 reads

Posted in Allen White on 26 May 2011

Survival Mode & Dodging Burn Out

One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience to avoid the problem altogether! That’s been the case for me over the past 6 months or so. I elected to make some changes in my work life at the… Read more

1 comments, 300 reads

Posted in SQLAndy on 26 May 2011

No Shrink-y Tempdb

I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal), and Aaron Bertrand (blog | @aaronbertrand) talking about shrinking tempdb and the potential issues.

I’ve never thought about it before, but someone… Read more

6 comments, 883 reads

Posted in The Voice of the DBA on 26 May 2011

SSRS Error: Unable to connect to remote server error

One fine day when I tried to connect to one of my staging report server I got the

“Unable to connect to remote server error”

I checked the report services & sql server (to which SSRS is mapped) services and both of them were running. I tried to connect to… Read more

0 comments, 1,430 reads

Posted in What I Learnt @ Work on 26 May 2011

Random Ordering of Results using NEWID

A discussion of how NEWID can be used to help randomize the results returned from a SQL query.

A scenario I hadn’t encountered until recently is as follows: How does one get a certain number of randomly selected records from a table? Nope, I didn’t need to do this for… Read more

0 comments, 634 reads

Posted in Help With SQL on 26 May 2011

SSRS 2008 R2: How to dynamically size your INDICATORS

The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS demonstration and I stumbled upon an additional feature that makes the indicator even more visually appealing. Using a not so obvious property of the indicator you can set its size.…

Read more

6 comments, 14,004 reads

Posted in SQLDownSouth on 25 May 2011

Recovery Model for Every Database

One thing that is enjoyable about my position is working with people who have no idea what SQL is besides “a difficult version of excel”. This gives me the chance to use what I have learned over the last couple of years and explain it the people who are using… Read more

0 comments, 705 reads

Posted in SQL Sandwiches on 25 May 2011

devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19

This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011. This three day event includes over 120 sessions, costs only $100, the least expensive full conference you can attend anywhere. While the conference is developer-oriented, it still offers plenty of… Read more

1 comments, 293 reads

Posted in SQL Aloha on 25 May 2011

Newer posts

Older posts