In this article, we will discuss about migrating to a contained database in SQL Server To this end, we will see how we can convert a “normal” database to a partially contained database in SQL Server. A typical security/user access configuration for a database would be set up as follows: Create the login (SQL or … Read more…
In this article, we will be discussing about Sequence objects in SQL Server 2012 and later, and see a relevant example. In an older article on our blog, we wrote on how someone can mimic the operation of Sequence Objects using other alternative ways. However, since SQL Server 2012 and later, Sequence Objects are available … Read more…
I have recently experienced an issue which had to do with a third-party application that was trying to retrieve some meta information from a specific SQL Server Instance. It was actually trying to retrieve the names of all the databases contained within that instance. However it was returning the following error message (app code excluded): […….] … Read more…
Yep, it’s that time of the year again! Waiting for that magic email saying: Dear Artemakis Artemiou, Congratulations! We are pleased to present you with the 2012 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions … Read more…
In yesterday’s post, we saw how we can retrieve log space information for all the databases within a SQL Server instance using the command DBCC sqlperf(logspace). Creating the Stored Procedure Today we will refine the process even more by creating a stored procedure that returns log space information for a given database! –****************************** –CREATING … Read more…
In the everyday life of a Database Administrator there is the task of maintaining the database logs in terms of size they occupy on the disk. Of course, there are automated maintenance and reporting procedures for this task as well as for many other tasks but it is not few the cases where the DBA needs to … Read more…
In an older post, we have discussed about, how you could rebuild all the indexes of a database in SQL Server by making use of the undocumented stored procedure “sp_MSforeachtable”. Retrieving Table Size Info using sp_MSforeachtable Another common task is when you want to retrieve size information for all the tables in a database. … Read more…
In this article, we’ll talk about Listing Directory Contents using T-SQL. Introduction In many cases during the development of a sophisticated SQL Server Agent job, you might need to access the file system. For example you might want to list the contents of a specific directory and based on the output to proceed to … Read more…
With just a few hours remaining for entering the new year 2012, I could do nothing else than preparing this blog post! In the end of every year, I gather up all my tweets for that year and post it here! It is a privilege to communicate with the SQL Server Community via all possible … Read more…
In this article, I present useful T-SQL knowledge for SQL Developers and DBAs. A few days ago I started writing an article that it would provide a set of useful tips on SQL Server topics that are met in the everyday life of DBA/Database Developer. The article is now completed and you can find it … Read more…
With SQL Server Denali RC0 released a few weeks ago, I am thinking of recording a webcast with topic its Database Engine features mainly focusing on the programmability area. To this end, I am conducting a poll in order to see if you are interested in attending such a webcast. If you are interested you … Read more…
In this article, we will be discussing about the following error message in SQL Server and how to easily resolve it: Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed… About this Error Message If you ever encounter issues when trying to create, add, or edit steps for a … Read more…
This article discusses about retrieving only the date from a datetime value in SQL Server. Why Converting Datetime to Date? There are many times where you might need to only retrieve the date from a datetime value. For example, you may have today’s datetime (2011-10-10 20:30:28.230) and you want to only get the following … Read more…
SQL Server 2012, among other introduced Sequence Objects. I am sure that sequence objects are widely known but let’s provide their definition in plain words: A sequence object allows you to set a global counter of values within the scope of a DBMS instance. Whenever you call the sequence object it returns a unique value … Read more…
In this article, we will discuss about using Proxy Accounts in SQL Server Agent jobs. We will talk about what this feature offers and how you can use it. Why Using Proxy Accounts in SQL Server Agent Jobs? When using SQL Server, in many cases you will might need to set up a SQL Server … Read more…