About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.
SQL SERVER – Generate Incremented Linear Number Sequence
Just a day ago, I received interesting question on this blog. Read original question here. This is very good question and after reading this question I quickly wrote small script as answer. Let us see the question and answer together.
Q. How can we generate incremented linear number in sql server as in oracle we generate in via sequence?
SQL SERVER – Sharpen Your Skills: Joins, Groupings, and Data Types
Read my article in SQL Server Magazine November 2007 Edition [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available
Download the latest SQL Server 2008 Community Technology Preview (CTP) and try out the latest features of SQL Server 2008! The SQL Server development team uses your CTP feedback to help refine and enhance product features. Download it today and send your feedback. Microsoft SQL Server 2008, the next release…
Read MoreSQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide – SQL Server, ColdFusion, ASP.NET
If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry…
Read More
SQL SERVER – 2005 – Best Practices for SQL Server Health Check
Here are few of the best practices one should follow for SQL Server Health Check.
SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard
I really enjoyed writing about SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects. Since then the I have received question that how to copy data as well along with schema. The answer to this is Database Publishing Wizard. This wizard is very flexible and works with modes like schema only, data only or both. It generates a single SQL script file which can be used to recreate the contents of a database by manually executing the script on a target server.
SQLAuthority News – Microsoft SQL Server 2005 Assessment Configuration Pack Download
Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act (GLBA) This configuration pack contains configuration items intended to help you establish and validate a desired configuration for your SQL 2005 servers in order to support your Gramm-Leach Bliley Act compliance efforts Microsoft SQL Server 2005 Assessment Configuration Pack…
Read MoreSQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Database Dilbert
This is my favorite Dilbert. Dilbert is an American comic strip written and illustrated by Scott Adams, first published in the year 1969.
SQLAuthority News – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007
Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007 This configuration pack contains configuration items intended to manage your SQL Server 2005 server roles, and was developed based on settings used by Microsoft IT in the configuration of these server roles. Microsoft SQL Server 2005 MSIT Intermediate…
Read More