The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,839 other subscribers

Archive for the ‘SQL Server’ Category

« Previous Entries
Next Entries »

Fixing 84b40000 error on SQL Server 2008 updates (like KB2977321 and KB2285068) via: Microsoft Community

Posted by jpluimers on 2015/07/14

When installing SQL Server 2008 Service Pack 3 related updates, some don’t like compressed directories (even if the database files themselves are uncompressed).

I found this holds at least for KB2977321 and KB2285068.

For x86 systems, ensure these directories are not compressed:

C:\Program Files\Microsoft SQL Server
C:\Program Files\Microsoft SQL Server Compact Edition

For x64 systems, ensure these directories are not compressed:

C:\Program Files\Microsoft SQL Server
C:\Program Files x86\Microsoft SQL Server
C:\Program Files x86\Microsoft SQL Server Compact Edition

–jeroen

via: Can not install KB2285068 Error Code 84B40000 – Microsoft Community.

Posted in Database Development, Development, Power User, SQL Server, SQL Server 2008, SQL Server 2008 R2, Windows | 1 Comment »

TSQL: showing database level and server level permissions

Posted by jpluimers on 2014/06/12

A few short scripts checking out the cause for TFS Integration Tools refuses to start despite an admin being able to create a TEST database. Read the rest of this entry »

Posted in Database Development, Development, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

Venn Diagrams of SQL Join queries (via: Data Visualization – Google+)

Posted by jpluimers on 2014/04/08

Some great venn diagrams of SQL JOINs via Data Visualization – Google+ of which I wish they were PNG:

Thanks to that link, I found the original article and images by C.L. Moffat!

Click on the image to view a larger version.

–jeroen Read the rest of this entry »

Posted in Access, Database Development, DB2, Development, Firebird, InterBase, MySQL, OracleDB, PostgreSQL, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7 | Leave a Comment »

SQL Server: when your database is in “Recovery Pending” mode

Posted by jpluimers on 2014/03/31

With SQL Server, when your database is in “Recovery Pending” mode don’t just start blindingly search google, but sit down as you might be causing more damage doing so.

After sitting down, read these two posts by Paul Randal | SQLskills.com from his SQL Server Corruption series:

  1. Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database.
  2. SQL Server EMERGENCY mode repair.

Then think about it before acting.

Though the simplest cause for “Recovery Pending” might be that a disk spin-up was slow, or a disk became full (and everything might just be dandy after the disk is available and there is enough room on it), make sure you read the above posts first before relying on the simple causes.

–jeroen

Posted in Development, Software Development, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged: , , | Leave a Comment »

SQL Server Management Studio does have a Registered Servers window (via: Server Fault)

Posted by jpluimers on 2014/03/26

One of the things I thought were missing from SSMS when coming from an ISQLW background was the “registered servers” window.

Well: it is still there, and this is how to set it up on an efficient way (:

–jeroen

via: mssql ssms – How can I have SQL Server Management Studio 2008 connect to my instances automatically? – Server Fault.

Posted in Database Development, Development, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

When opening SQL Server Management studio with ssms command (+parameters) I need the Object Explorer to be filled and point to the right location – Stack Overflow

Posted by jpluimers on 2014/03/25

As a SQL Server developer, most of us make extensive use of SQL Server Management Studio.

With lots of production database, I have a directory full of shorcuts that pre-fill server/database/… on the command-line.

One of the drawbacks these shortcuts have is that the Object Explorer stays empty, and does not sync with the currently active Server/Database.

While browsing to solve that, I found that the

Alt+F8 shortcut will focus the SERVER in the Object Explorer.

This was explained by StackOverflow user Andrei Rantsevich who had this great answer on StackOverflow: Read the rest of this entry »

Posted in Database Development, Development, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

Database Workbench v4 – version: 4.4.5. got released (via: News @ Upscene Productions)

Posted by jpluimers on 2014/03/19

Today, Version 4.4.5 of Database Workbench got released.

It mainly is a bugfix release (15 out of 18 issues were bugfixes, of the rest, 2 are feature requests, 1 enhancement): List of items new/enhanced/fixed in Product: Database Workbench v4 – version: 4.4.5.

Download from the trial/lite download page, or from the customer download page.

Enjoy (:

–jeroen

via: News @ Upscene Productions.

Posted in Database Development, Delphi, Development, Firebird, InterBase, MySQL, NexusDB, OracleDB, Software Development, SQL Server, Sybase SQL Anywhere | Leave a Comment »

SQL Server 2014 is done: Hekaton, Azure integration (via: Tim Anderson’s ITWriting)

Posted by jpluimers on 2014/03/19

Interesting: SQL Server 2014 is done: Hekaton, Azure integration « Tim Anderson’s ITWriting.

Most important feature is the in-memory database engine (OLTP).

Because the in-memory OLTP it is so highly optimized there are quite a few T-SQL features missing, but usually it is a magnitude faster than the disk based database engine.

For limitations, see Transact-SQL Constructs Not Supported by In-Memory OLTP.

–jeroen

Posted in Database Development, Development, SQL Server, SQL Server 2014 | Leave a Comment »

SQL Server: learned that you can pass a Style to CAST and CONVERT (Transact-SQL)

Posted by jpluimers on 2014/03/19

Funny way to learn something new:

I hardly use CAST and CONVERT (Transact-SQL), and when I do, it is the standard SQL-92 way.

But a while ago, I came across some code like this:

CONVERT(DATETIME, "31/12/2013", 105);

and wondered what the 105 was.

And it appeared to convert from the Italian date format to DateTime. And that it has been there since at least SQL Server 2000, probably earlier.

Not sure why the passed slashes (/) in stead of dashes (-) as separators though.

There are styles for these groups of conversions:

  • Binary
  • Date/Time
  • Float/Real
  • Money/Smallmoney
  • XML

Never to old to learn something new (:

–jeroen

Posted in Database Development, Development, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

How to setup and use a SQL Server alias

Posted by jpluimers on 2014/03/03

Just in case I need this ever again: How to setup and use a SQL Server alias.

Posted in Database Development, Development, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Leave a Comment »

« Previous Entries
Next Entries »