|
|
-
|
|
I have been helping a few people to migrate their blogs from blogger.com to beyondrelational.com. As part of this, I had to deal with the XML export file generated by blogger.com which contains information of all the posts, comments etc. I wrote a...
|
|
-
|
|
Recently when i was working in replication task. It was to just add new subscribers to an existing publication. Some of there added successfully but some of failed due to replication component is missing. Before you go ahead in details i would like to r...
|
|
-
|
|
If you use simple recovery model for your SQL database, you can do both database backups as well as file backups. Your restoration needs may vary depending on the scenario. ...
|
|
-
|
|
DDL Changes Log additional changes in script to get client IP...
|
|
-
|
|
SQL Server has the ability to enforce organzational security policies for SQL login passwords. This can be bypassed by using the CHECK_POLICY clause in the CREATE LOGIN statement. However, when using hashed passwords, no such restrictions seem to apply....
|
|
-
|
|
How to create DDL Change Log using Service Broker,for multiple databases on a single instance....
|
|
-
|
|
Often I see lot of SQL deveopers complaining about the error when using datetime values in their queries. The common error that almost everyone would heard about is "Conversion failed when converting date and/or time from character string."
But in gener...
|
|
-
|
|
Recently we have seen the post for database size information and script used for the same too. Hope you liked that post. Sometime we need to have details like database size for growth and disk planning as we viewed in earlier post, same way i am repeati...
|
|
-
|
|
This blog will explain how we can create separate columns out of a delimited (Pipeline or comma) values...
|
|
-
|
|
Working with SQL Server logins and users is one of the most important and critical activities when moving databases from one SQL Server instance to another. The hash value for SQL Server logins created in SQL 7.0 or earlier are 16-bit values and are no longer compatible with SQL Server 2012....
|
|