SQLAuthority News - Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundament......
SQL SERVER - Fix : Error : Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
I have seen developer confused many times when they receive following error message.Msg 325, Level 15, State 1, Line 7Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptleve......
SQL SERVER - Transaction and Local Variables - Swap Variables - Update All At Once Concept
This article is inspired from two sources.1) My year old article - SQL SERVER - Effect of TRANSACTION on Local Variable - After ROLLBACK and After COMMIT2) Discussion with SQL Server MVP - Jacob Sebastian - SQLAuthority News - Author Visit - SQL Hour at Patni Computer SystemsI usually summarize my ......
SQL SERVER - Introduction to CLR - Simple Example of CLR Stored Procedure
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are no......
GIS and SQL Server 2008: Making Maps with your Data
When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what sort of things can you do with GIS Data? We asked an expert!...Did you know that DotNetSlackers also publishes .net artic......
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2
A year ago I wrote post about SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice where I have discussed two different methods of getting datepart from datetime.Method 1:SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))Method 2:SELECT CONVERT(VARCHAR(10),GETDATE(),111)I have s......
Deploying changes to SQL Server with SQL Packager is now a lot more powerful
With the latest version of Red Gate SQL Packager v6, the user can specify any script to package. It is even possible to mix and match scripts generated by SQL Compare, SQL Data Compare, SQL Refactor and SQL Packager to create a deployment script. Suddenly, Database deployment has got a whole lot ea......
SQL SERVER - Get Common Records From Two Tables Without Using Join
I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly.Sachin Asked:Following is my scenario,Suppose Table 1 and Table 2 has ......
SQL Server 2005 Driver for PHP Cumulative Update
Microsoft has released an updated SQL Server 2005 Driver for PHP. The SQL Server
2005 Driver for PHP download is available to all SQL Server users at no additional
charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the
reading and writing of SQL Server data from within ......
SQLAuthority News - Ahmedabad SQL Server User Group Meeting - October 2008
Tomorrow is third Saturday of the Month and every third Saturday we have Ahmedabad User Group Meeting. Our user group is growing and getting interesting. Everybody who attended last months User Group (UG) Meeting realized that how important it is to attend UG meetings. UG President Jacob Sebastian ......
SQL SERVER - Downgrade Database to Previous Version
Today I am writing on the topic which I do not like to write much. I enjoy writing usually positive or affirmative posts. Recently I got email from two different DBA where they upgraded to SQL Server 2005 trial version on their production server and now as their trial version was expire they wanted......
New Date Data Types in Microsoft SQL Server 2008
In August 2008 Microsoft released
the latest version of the database server software, SQL Server 2008. SQL
Server 2008 includes a number of new features not found in SQL Server 2005, including: a terser T-SQL syntax; the new
MERGE statement; new data types and functions; enhanced encryption
and X......
SQL SERVER - Introduction and Example of UNION and UNION ALL
It is very much interesting when I get request from blog reader to re-write my previous articles. I have received few request to rewrite my article SQL SERVER - Union vs. Union All - Which is better for performance? with examples. I request you to read my previous article first to understand what i......
Cold Turkey with SQL Server Management Studio
Someone bet Phil Factor that he couldn't stop using SSMS for a fortnight just to see how he'd cope. With some trepidation, he accepted the wager. After an uncomfortable few days, he suddenly felt happier and purer in spirit...Did you know that DotNetSlackers also publishes .net articles written by ......
SQL SERVER - Get Numeric Value From Alpha Numeric String - UDF for Get Numeric Numbers Only
SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see User Defined Function, which I wrote few days ago, which will return only Numeric values from AlphaNumeric values.CREATEFUNCTION dbo.udf_GetNumeric(@strAlphaNumeric VARCHAR(256))RETURNSVARCHAR(256)ASB......
SQLAuthority News - Book Review - Pro SQL Server 2005 Replication (Definitive Guide)
Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover)by Sujoy Paul (Author) Link to Amazon (This is not affiliate link)Quick Review:This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of high......
SQLAuthority News - SQL Injection - SQL Joke, SQL Humor, SQL Laugh
It has been long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by many users. I did not publish it till now as it has been quite popular and I believed many people has already seen it. However, recently by one [...]...Did you know that D......
SQL Server 2008: The New Data Types
Brad continues his helicopter-level view of the most interesting new features of SQL Server 2008 with a look at the new data types, their use and their significance....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles i......
SQLAuthority News - Download - Microsoft SQL Server 2008 Feature Pack, August 2008
Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest ver......
SQL SERVER - 2008 - Enhenced TRIM() Function - Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
After reading my article SQL SERVER - 2008 - TRIM() Function - User Defined Function, I have received email and comments where user are asking if it is possible to remove trailing spaces, leading spaces, white space, tabs, carriage returns, line feeds etc.I found following script posted by Russ and......
SQL Server Analysis Services - Manipulating Data Source Views
In this article, Nidal demonstrates the steps required to manipulate Data Source Views using SQL Server Analysis Services. After a short introduction, he examines the steps in detail with the help of relevant screenshots and code listing.Did you know that DotNetSlackers also publishes .net articles......
SQL SERVER - 2008 - TRIM() Function - User Defined Function
I just received following question in email by James Louren.“How come SQL Server 2000, 2005 does not have function TRIM()? Is there any way to get similar results.What about SQL Server 2008?”James has asked very interesting question. I have previously wrote about SQL SERVER - TRIM() Function - UDF ......
SQL Summit 2008: I Am the Governor
After Kalen's excellent keynote our SQL Server MVP Tibor Karaszi entered the stage to dive into the new Resource Governor, one of the features that are there to strengthen the Maintainability aspect of SQL Server. The resource governor is added to the Enterprise version of SQL Server 2008 and give......
SQL Summit 2008: Key Note
SQL Summit has been touring Sweden this week and today we've finally got to the grand finale at "China Teatern" in Stockholm. With 600+ attendees in all four cities the tour has been a blast with a lot of interesting discussions. This morning I had the good fortune to listen to Kalen Delaney giving......
SQL Summit 2008: The Compression Session
At TechEd (http://www.lowendahl.net/showShout.aspx?id=169) last year this feature got a massive round of applauds. The ability to compress backups and data- and log files. Kalen gave a great talk on this today where she show cased the benefits you get from the new compression features. Since large......
The Bejeweled Puzzle in SQL
Alex Kozak provides another SQL puzzle to hone your SQL Skills with....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
Aspose.Total for Reporting Services Q3 2008 Released
Aspose.Total for Reporting Services Q3 2008 release includes many new and improved features in this suite of Microsoft SQL Server Reporting Services Rendering Extensions. Now you can export RDL reports to multiple file formats like DOC, DOCX, HTML, RTF, WordML, PDF, PPT, PPS, XLS, XLSX and Spreadsh......
SQLAuthority News - SQL Server 2008 - Microsoft Certifications for 70-432 70-433 70-450 70-452
I have received many emails requesting information about SQL Server certifications examples. Microsoft has released new set of exams for SQL Server 2008 certifications. I am listing them here for quick reference.Exam 70-432 - TS: Microsoft SQL Server 2008, Implementation and MaintenanceInstalling a......
SQL SERVER - 2008 - High Resolution Wallpaper and Screen Saver
Recently I came across two very interesting ‘objects’ of SQL Server 2008.SQL Server 2008 High Resolution Wallpaper (click on image to see larger version)SQL Server 2008 Screen Saver Click Here to DownloadReference : Pinal Dave (http://www.SQLAuthority.com)...Did you know that DotNetSlackers also pu......
SQLAuthority News - Author Visit - SQL Hour at Patni Computer Systems
Ahmedabad SQL Server User Group has started organizing a special event, “SQL Hour”, where we visit IT companies and interact with the SQL Server professionals. We had the first meeting this Saturday, 4th October 2008 at Patni Computer Systems, Gandhinangar.This meeting was lead by SQL Server User G......
Microsoft Outlines Next-Generation Databases
Microsoft is planning to enhance the BI capabilities in the next version of its flagship SQL Server database, the company revealed today, as it kicked off its second annual Business Intelligence Conference in Seattle....Did you know that DotNetSlackers also publishes .net articles written by top kn......
Named Capture for SQL Server connection strings
Capture the information from a SQL Server connection stringDid you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
...
SQL Server Analysis Services - Creating Data Source Views
Now it is time to go practical in our business intelligence project as we have provided enough concepts. The first step in creating BI projects is to provide data sources to build your model out of. In this article, Nidal examines the different aspects of creating data source views using SQL Server......
SQLAuthority News - Upgrade SQL Server With SA Renamed - Rebuild System Databases - SQL Server 2008
I recently came across two interesting blog post by PSS SQL Server Engineers. They have written two interesting SQL Server 2008 related post and it can be very helpful to those who come across the issues mentioned in them.How to Rebuild System Databases in SQL Server 2008Rarely but sometime there i......
SQL SERVER - 2008 - Fix Connection Error with Visual Studio 2008 - Server Version is not supported - VS SP1 ISO Download
I previously wrote article SQL SERVER - 2008 - Fix Connection Error with Visual Studio 2008 - Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which was downloading......
SQLAuthority News - Cumulative update package 1 for SQL Server 2008
Cumulative update package 1 for SQL Server 2008 is released.Click on link : http://support.microsoft.com/kb/956717/en-usUpdate : I have received few emails where developer did not find where to click on the support page to download the update package. Following image describes the link which is on ......
Using Powershell to Generate Table-Creation Scripts
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what......
SQLAuthority News - Download - Visual Studio Team System 2008 Database Edition GDR September CTP
In addition to providing support for SQL Server 2008 database projects, this release incorporates many previously released Power Tools as well as several new features. The new features include distinct Build and Deploy phases, Static Code Analysis and improved integration with SQL CLR projects. Dat......
SQL Server - 2008 - Cheat Sheet - One Page PDF Download
Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and [...]...D......
SQL Server Analysis Services - UDM
In this article, Nidal examines the concept of Unified Dimensional Model (UDM) in SQL Server. After a short introduction, he provides a short overview of Relational and Dimensional model in addition to UDM.Did you know that DotNetSlackers also publishes .net articles written by top known .net Autho......
SQLAuthority News - Download - Microsoft SQL Server 2008 Books Online (August 2008)
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.Books Online includes the following types of information:Setup and upgrade instructions.Information about new features and backward comp......
Amazon`s EC2 plays nice with Windows
Amazon's Elastic Compute Cloud (EC2) hosted infrastructure service for developers will expand its choice of operating systems and databases to include Microsoft's Windows Server and SQL Server....Did you know that DotNetSlackers also publishes .net articles written by top known .net A......
Backup Compression with SQL Server 2008
No need to turn to third-party tools to keep your databases as small as possible. It's in SQL Server 2008 now....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look......
Retrieving the Just-Inserted ID of an IDENTITY Column Using a SqlDataSource Control
ASP.NET offers a variety of tools and mechanisms for working with database data, including a number of data source controls, such as the SqlDataSource,
ObjectDataSource, and LinqDataSource, among others. The SqlDataSource is one of the most basic data source controls as it operates directly agains......
SQL Insider: Backup Compression with SQL Server 2008
No need to turn to third-party tools to keep your databases as small as possible. It's in SQL Server 2008 now....Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look......
SQL SERVER - Example of PIVOT UNPIVOT Cross Tab Query in Different SQL Server Versions
Transforming rows to columns (PIVOT/CROSS TAB) and columns to rows (UNPIVOT) may be one of the common requirements that all of us must have seen several times in our programming life. SQL Server 2005 introduced two new operators: PIVOT and UNPIVOT that made writing cross-tab queries easier.My frien......
And so it came to PASS...
On 18-21 November this year, in the great city of Seattle, PASS will be holding their 10th annual conference. If you work with SQL Server, you should attend if you possibly can. It's an independently-organized summit, but with the hand of Microsoft firmly up its sweater....Did you know that DotNetS......
SQL Response: The dim sum interview
Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They had just finished a new Red-Gate product called SQL Response. Away from the office, they described the fourteen month software project that had been dominating their lives; and they were still a......
SQLAuthority News - Security Update for SQL Server 2005 Service Pack 2
Developers who are using SQL Server Service Pack 2 must install this security patch for it. A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing th......
Log4net Dashboard version 2.4 released
Log4Net Dashboard is a log viewer that can read log events from a variety of targets, including:
Microsoft SQL Server
Oracle SQL Server
XML Files
Windows Event Log
The main page in Log4Net Dashboard is the dashboard page which gives the user instant information on an appliction's logging s......