March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Software Development, SQL Download, SQL Utility
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…
Read More

SQL Server – 2008 – Cheat Sheet – One Page PDF Download

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
Best Practices, Database, DBA, Software Development, SQL Cheat Sheet, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server, SQL Utility

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 for novice developers it is good to keep all the important SQL Script and SQL Statements handy.

I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.

Read More

SQL SERVER – Guidelines and Coding Standards Part – 2

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, Software Development, SQL Coding Standards, SQL Scripts, SQL Stored Procedure
To express apostrophe within a string, nest single quotes (two single quotes). Example: SET @sExample = 'SQL''s Authority' When working with branch conditions or complicated expressions, use parenthesis to increase readability. IF ((SELECT 1 FROM TableName WHERE 1=2) ISNULL) To mark a single line as comment use (–) before the statement.…
Read More

SQL SERVER – Guidelines and Coding Standards Part – 1

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Index, SQL Joins, SQL Scripts, SQL Stored Procedure
Use “Pascal” notation for SQL server Objects Like Tables, Views, Stored Procedures. Also tables and views should have ending “s”. Example: UserDetails Emails If you have big subset of table group than it makes sense to give prefix for this table group. Prefix should be separated by _. Example: Page_…
Read More

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, Software Development, SQL Download, SQL Error Messages, SQL Server Management Studio, SQL Service Pack
While attending conference SQLAuthority Author Visit – Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are…
Read More

SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SharePoint, Software Development
SharePoint is one interesting software from Microsoft. My outsourcing location unit is working on one large project of SharePoint. Based on users feedback and overwhelming response to article SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name I am posting one more article which…
Read More

SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SharePoint, Software Development, SQL Error Messages
If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website. When you change the physical server name the SharePoint is already connected to the SQL instance…
Read More
Exit mobile version