sorted by:
best match first |
newest listings first
Featured Listings
- Mobile Client Software Factory on VS 2008? Sure!
One of my customers was interested in some of the cool features of the Mobile Client Software Factory , but they wanted to develop on Visual Studio 20
From: <ChristophDotNet - ASP.NET - 9/25/2008
- SQLAuthority News – USB Drive Fails to Copy Large File
I am currently traveling on a month-long training assignment for Business Intelligence. For demonstration purposes, I use Virtual PC files and hands-o
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why t
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Backup master Database Interval – master Database Best Practices
During a recent consultancy project, I was asked to review a Database Backup plan. While going through the plan, I noticed that there was no backup fo
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In t
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – A Quick Guide to Twitter
I am a very big fan of Twitter. I have been using it for quite sometime now and I think it is a very convenient way to stay connected with friends, fa
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Interview with SQL Server MVP Glenn Berry
Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and has a whole collection of Microsoft cer
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL Server – Multiple CTE in One SELECT Statement Query
I have previously written many articles on CTE. One question I get often is how to use multiple CTE in one query or multiple CTE in SELECT statement.
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Humorous SQL Cake – Funny SQL Cake
I received the following interesting images in email during the past 2 months. I think they are superbly hilarious! I received them from various peop
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime
I have seen scores of expert developers getting perplexed with SQL Server in finding time only from datetime datatype. Let us have a quick glance look
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
When I am not blogging, I am typically working on SQL Server Optimization projects. Time and again, I only have access to SQL Server Management Studio
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Forgot the Password of Username SA
I just received a call from an old friend with whom I used to work in Las Vegas. He told me about a password-related issue he faced in his organizatio
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Introduction to SQL Server 2008 Profiler
Introduction
SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
Does the proposed eGov Standards Policy benefit all or only a chosen few?
As a wider audience comes to accept new technology, so the technology itse
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Get Query Plan Along with Query Text and Execution Count
Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following ha
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
This error is quite common and I have received it few times while I was working on a recent consultation project.
Cannot open database requested by t
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online
Indias premier online technical event is back again with the 6th Edition of Microsoft Virtual TechDays, scheduled to be held between August 19 -21, 20
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
SQL Server MVP and my personal friend Jacob Sebastian has published my interview on subject of Beyond Relational on his famous site Beyond Relational.
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Measure CPU Pressure – CPU Business
Many a time, DBAs face the following question: can the CPU handle the current transaction? I have seen many DBAs getting confused on whether they shou
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)
SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your organization scale with confidence and improve IT and developer effi
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture – the new concept introduced
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – Get Query Plan Along with Query Text and Execution Count
Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following ha
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
This error is quite common and I have received it few times while I was working on a recent consultation project.
Cannot open database requested by th
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online
Indias premier online technical event is back again with the 6th Edition of Microsoft Virtual TechDays, scheduled to be held between August 19 -21, 20
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009
- SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
SQL Server MVP and my personal friend Jacob Sebastian has published my interview on subject of Beyond Relational on his famous site Beyond Relational.
From: Journey to SQL Authority with Pinal Dave - ASP.NET - 8/20/2009