Latest 10 Posts
Support for SQL Server on Hyper-V
Abstract from Carpe Datum (Indexed 2008-08-27):
Many of us use SQL Server in a virtual environment, but as you know it's been difficult to find out what the support policy is for that, depending on the Virtual Environment. Well, for Hyper-V, there's no question: It has support. To find out exactly...(truncated)...
Using Locking Like Synchronization Object
Abstract from PSS SQL Server Engineers (Indexed 2008-08-27):
This post is more of a T-SQL trick and NOT a recommendation practice, but since I addressed this in a recent customer case I thought I would share it. Problem: Application needs to lock a row for the duration of the transaction and ensure no d...(truncated)...
Why you should read the Release Notes for SQL Server 2008
Abstract from PSS SQL Server Engineers (Indexed 2008-08-26):
Do the release notes really ever contain anything that can help you with your deployment of a product? Well in the case of SQL Server 2008, the answer is YES. Here are the following benefits for using the Releases Notes which can be found at the foll...(truncated)...
SQL Server 2008, Report Builder
Abstract from Euan Gardens BLOG (Indexed 2008-08-25):
Ok so not everything for SQL Server 2008 is available yet, Report Builder is going to have a lag, you can find RC 1 here. This should work with RTM SQL 2008. Here are some of the changes from the last RC;Easy to use wizards for creating table, matrix...(truncated)...
SQL Server Express 2008, Advanced Services and Tools now available
Abstract from Euan Gardens BLOG (Indexed 2008-08-25):
Get it here.That should not be all the pieces of SQL Server 2008 available.[Image]
MOM 2005 Management Pack for SQL Server 2008 is Available
Abstract from Carpe Datum (Indexed 2008-08-25):
We've completed the work on the Microsoft Operations Manager (MOM) "Management Pack" for SQL Server 2008. MOM allows you to monitor and manage Microsoft and even other vendor's servers, so if you have this software in your shop you can download...(re...(truncated)...
Report Builder 2.0 - RC1 Release
Abstract from SQL Server Reporting Services Team Blog (Indexed 2008-08-25):
[Image]Report Builder 2.0 RC1 is now available on Microsoft Download Center. Use this link for download. RC1 delivers improvements in the following areas compared to RC0:Easy to use wizards for creating table, matrix and chart data regions. Support...(truncated)...
IsNumeric Returns (1/TRUE) and I Expected (0/FALSE)
Abstract from PSS SQL Server Engineers (Indexed 2008-08-25):
The string '100,200,300' has fooled many a customer and support engineer alike. select cast('100,200,300' as bigint) Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to bigint. One might argue that this is a bigi...(truncated)...
FAQ: Switching between SQL Server 2008 edtions
Abstract from SQL Server Express WebLog (Indexed 2008-08-24):
There is an extra step that you need to take when upgrading from one edition of SQL Server 2008 to another, for example when upgrading from Express to Express with Tools. This extra step is called Edition Upgrade (sometimes SKU Upgrade) and the net r...(truncated)...
Updates (fixes) to sp_helpindex2
Abstract from Kimberly Tripp (Indexed 2008-08-24):
I first posted an update to sp_helpindex here. My version of sp_helpindex was solely to expand what sp_helpindex showed and adds 1 or 2 things based on version: for SQL2005+ it adds included columns and for SQL2008 it al...(truncated)...
View All Posts...
Latest 10 Jobs
SQL Server DBA 7657S - RiverPoint - Kansas City, MO
(Indexed 2008-08-28):
and development MS SQL Server environments including... as a SQL Server DBA in a medium to large environment gaining knowledge and experience with SQL Server 7.0... (From Computerwork.com)
Senior .Net/SQL Server Developer - MATRIX - Chicago, IL
(Indexed 2008-08-28):
CRTP744081Senior .Net/SQL Server DeveloperFast... Required Skills C# ASP.NET SQL Server 2000 SQL Server 2005 Preferred skills include: SQL Server Reporting... (From Monster)
SQL Server 20002005 Secondary ASPNET Developer - Beta-Search, Inc. - Jersey City, NJ
(Indexed 2008-08-27):
with the use of Microsoft SQL Server, Transaction SQL and/or VB ASP.NET. Successful candidate must have previous experience on working with SQL Server in a... (From NewYorkJobs.com)
Database Administrator, MS SQL Server/Sybase - NBC Universal - Universal City, CA
(Indexed 2008-08-27):
managing and providing support for enterprise MS SQL SERVER/SYBASE technology platform that align with the... practices for MS SQL Server/Sybase platform... (From NBC Universal)
SQL Server 2005 Developer with SSIS and Visual Studio Experience - Genesis10 - Charlotte, NC
(Indexed 2008-08-27):
opportunitiesSQL Server 2005 Developer with SSIS and Visual Studio ExperienceJob Description: Genesis10 has an excellent opportunity for an SQL Server 2005... (From Monster)
Database Administrator - Oracle, DB2, UNIX/PERL, SQL Server, Sybase - Fidelity Investments - Flower Mound, TX
(Indexed 2008-08-26):
Oracle, DB2, Sybase, SQL Server) Database Management... preferred, SQL Server acceptable)Skills and KnowledgeOracle DBA required; DB2, Sybase desirable SQL... (From Monster)
SQL Server DBA - Kforce Professional Staffing - Columbus, OH
(Indexed 2008-08-26):
POSITION... SQL Server DBA... Job Description:Specific functions of the SQL Server DBA... (From Monster)
ASP ASPNET SQL Server Developer Sr - Safari Technical Staffing - New York, NY
(Indexed 2008-08-26):
ASP SQL Server Developer (Sr Systems Analyst) Direct... ROLE Our client is seeking a dedicated ASP SQL Server (Sr Systems Analyst) professional who is highly... (From NewYorkJobs.com)
SQL Server Database Administrator - SMS.ac, Inc. - San Diego, CA
(Indexed 2008-08-26):
SQL Server Database Administrator Location: San Diego... administer SQL Server 2005 databases on Windows 2000/2003 Enterprise servers in a multiple database server... (From Itzbig)
SQL Server DBA - TMG and EQQUS - Woodland Hills, CA
(Indexed 2008-08-25):
TMG and EQQUS SQL Server DBA Our client, A world class company located in the North of L.A. County is seeking a contract to perm SQL Server DBA. Fun company... (From LAJobHunter.com)
Reporter Network