|
|
-
|
|
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....
|
|
-
|
|
This post is to test the “GetRecentPosts” for Windows Liver Writer integration. Please ignore this if you reached here....
|
|
-
|
|
Integration Service Catalog in SSIS 2012...
|
|
-
|
|
SQL Server 2012 Release with lots of Enhancements in Database Engine functions, SSIS, SSRS and some of new services like Data Quality Server and Master Data Service....
|
|
-
|
|
Yesterday I have written a blog post about Where I can find SQL Generated by Entity Framework? and same day I got request from one of the our reader Ramesh that how I can find SQL generated by Linq-To-SQL?. I thought its a good idea to write a blog post...
|
|