Subscribe to latest posts
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.…
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…
0 comments, 734 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
0 comments, 1,502 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…
12 comments, 524 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, 714 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, 303 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, 222 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, 160 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:
- Connect Item on Import/Export Wizard (5/20/2010) – Connect item that would be great to have up voted.
- Doing Something…
0 comments, 121 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, 119 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, 192 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, 242 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
- Karen Lopez (Twitter) of InfoAdvisors ,
- Adam Jorgensen (Twitter, blog) of PragmaticWorks, and
- Melinda White (email
1 comments, 233 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, 465 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, 148 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, 581 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, 873 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, 483 reads
Posted in Help With SQL on 26 May 2011
SSRS 2008 R2: How to dynamically size your INDICATORS
6 comments, 1,666 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, 438 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, 189 reads
Posted in SQL Aloha on 25 May 2011