2016-11-07 02:39
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to see all that happening for real, In-Person!! I was always wondering if… Read More
Blog Directory > Software Blogs > Programming Blogs > SQL Server Citation programming Blog >
Sql Server Citation Blog
hemantgirisgoswami.blogspot.com
Tags:
sql server
server
luan
sqlfamily
attended
database
july reading system
discount code
running dbcc shrinkfile
unique discount code
SQL Server Citation is a SQL Server blog by Hemantgiri S. Goswami, Surat,India. He is a SQL Server Specialist and SQL Server MVP,Author, President and Leader of Surat User Group.
2016-11-07 02:39
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to see all that happening for real, In-Person!! I was always wondering if… Read More
2016-11-07 02:39
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to see all that happening for real, In-Person!! I was always wondering if… Read More
2016-07-25 09:41
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have been added to improve its performance. It helps the database administrators to mana… Read More
2016-06-24 12:23
Overview of the SituationWhile accessing data files in SQL Server, many issues may occur that may lead to frustrating situation for users. One such situation occurs when user are running DBC… Read More
2016-05-15 03:27
SQLPASS SUMMIT 2016 is around, only few months left for this super event. Probably you all would have heard about the SQLPASS SUMMIT but let me just brief you about this event. This event ha… Read More
2016-04-26 13:22
IntroductionSQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used on Business platforms for data ana… Read More
2016-04-07 07:32
Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in the event of a disaster. It can only be implemented in databases that have f… Read More
2016-01-20 12:54
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on 23rd Jan 2016 at 5 PM. Well, this will be the first appearance as a speak… Read More
2016-01-12 02:28
Greetings of the day!!I am getting frequent emails with questions why I do not write as often I used to write earlier. I know, I got very few blog posts since 2013; the reason was that I had… Read More
2013-09-06 05:05
Few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM Aspirants. This announcement has… Read More
2013-08-08 05:00
Introduction People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files) at one go out-of-box. And I am sure that… Read More
2013-05-11 04:04
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting in… Read More
2013-04-29 07:50
IntroductionRecently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011. The idea was to show a Calendar for the selected month and each cell… Read More
2013-03-12 04:36
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are times when we need to find out records matching a criteria from all the tabl… Read More
2013-03-12 04:33
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic which I could manage to come up at that point is shared in the below script.DECLA… Read More
2012-12-25 03:33
Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine. In recent past we had a situation where customer asked us to move MASTER dat… Read More
2012-12-04 05:13
Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.m… Read More
2012-10-15 06:32
Problem Statement SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does not provides any direct way to convert it to PROPER format. A… Read More
2012-09-02 06:08
It's my bad that I did not made a post since long lately. I would not make an excuse like I was busy, rather, I would say I am little lazy DBA, but I now onward I will try to post blog more… Read More
2012-08-10 18:39
In recent past we have a situation where in we required to move MSDB, Model and Master databases to new location, the reason being faulty drive. While moving system databases to new location… Read More
2012-03-28 07:13
Introduction Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A general table structure which people come up to store this kind of data is … Read More
2012-03-12 12:21
On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this… Read More
2012-03-08 13:15
In my previous post we see how to move MSDB database, today we will see how to move or relocate MASTER database. While moving MASTER database we’ll have to consider few other things li… Read More
2012-03-06 04:34
`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed what’s new in SQL Server 2012 setup, MS has released SQL Server 2012 t… Read More
2012-03-02 04:28
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second draft of this book. SQL Server MVP Ross Mistry and Stacia Misner has covered Admin… Read More
2006-06-07 11:16
Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit 2015, and now when I hear back from him, I am really very excited th… Read More
2006-06-07 11:16
I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas. Yesterday I decided to get my hands dirty with one of this – SSAS. Few m… Read More
2006-06-07 11:16
Recently I had a chance to speak my friend Ashish Sharma who is my colleague too. We were discussing Project Management topics (he recently passed PMP and ACP). Our discussion ended at very… Read More
2006-06-07 11:16
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The MSDB has grown to 20 Gigs. Well, you would say, what is the big deal with that? 20 gigs is no… Read More
Subscribe to Sql Server Citation
Get updates delivered right to your inbox!