It is indeed a bit day for me. I am very happy that I have 1 million visitors in just last 1 year. Read my story of 365 days.
SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1
Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local…
Read MoreSQLAuthority News – Few Add-ons for SQLAuthority
SQL Random Article Find Post SQL Jobs Search SQLAuthority Subscribe Email Update SQLAuthority Feed My Other Blog Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Best Articles on SQLAuthority.com
Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility
SQL SERVER – Cursor to Kill All Process in Database SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored procedure SQL SERVER – Shrinking Truncate Log File – Log Full SQL SERVER – Simple Example of Cursor SQL SERVER – UDF – Function…
Read MoreSQLAuthority News – Best SQLAuthority Articles on Other Popular Sites
Best SQLAuthority Articles on Other Popular Sites SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE (SQL Server Magazine) SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards (dotnetslackers.com) Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Best Downloads on SQLAuthority.com
Best Downloads on SQLAuthority.com SQL SERVER – Query Analyzer Shortcuts SQL Server Interview Questions and Answers Complete List Download SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts) SQL SERVER Database Coding Standards and Guidelines Complete List Download SQL SERVER – Data Warehousing Interview Questions and Answers…
Read MoreSQLAuthority News – First Birthday of Blog – 365 Post in One Year
Hello Everyone, Today is birthday of this blog. Exactly one year ago, I started this journey of SQL Server and today I have reached first mile stone. There are so many great experience I had during this year. One thing I enjoyed the most is My Extremely Knowledgeable and Friendly…
Read More
SQL SERVER – Importance of Master Database for SQL Server Startup
I have received following questions. I will list all the questions here and answer them together.
What is the purpose of Master database?
SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
Business Intelligence Business intelligence is a method of storing and presenting key enterprise data so that anyone in your company can quickly and easily ask questions of accurate and timely data. Effective BI allows end users to use data to understand why your business go the particular results that it…
Read MoreSQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers
Just a day ago, I received question in email regarding my article SQL SERVER – 2005 Disable Triggers – Drop Triggers. Question : How to disable all the triggers for database? Additionally, how to disable all the triggers for all servers? Answer: Disable all the triggers for a single database:…
Read More