I recently needed to enable Mixed Mode Authentication on a SQL Server instance, so I will demonstrate how to go about setting this up. It is a pretty easy process, but I figure I'll document it nicely here. Perhaps I will come back to this later to reference this. Who knows? First you will need to connect to the SQL Server instance using SQL ...

A while back I blogged about how to install sql server management studio, and it got a reasonable amount of feedback. More recently, Steve Smith posted a response to it where he highlights a better way of installing Management Studio. The method I outlined doesn't seem to work in every instance, so in his response Steve supplied a method which ...

Aspose.Words for Reporting Services is a rendering extension for Microsoft SQL Server 2000, 2005 and 2008 Reporting Services (32 bit & 64 bit). It allows you to export your RDL reports to flow layout documents and provides comprehensive support for exporting them to DOCX, DOC, RTF and WordprocessingML formats. All RDL report features including ...

HiTHANK YOU for giving the opportunity to present this exciting opportunityI have long term ASP.NET and SQL Server opportunity for my government client.Client is looking for expert ASP.net and SQL Server  and other .net related technologies or nice to have.SQL Server queries and expertise is compulsoryLoc:COLUMBUS,OhioDuration: 6 months  ...

I often write queries in SQL Server Management Studio to find different bits of information about which I am curious. This is quite easy and I discover a lot of useful and interesting things this way. You might ask why I am writing this blog post. I'll first say that I try to share these little tidbits with others. Sure I could bring people over ...

Outside of SQL it would be quite easy to number the rows returned from query, but to do so inside of the SQL is a bit more difficult. I recently wanted to be able to number the rows returned from a query in a stored procedure. I am using SQL Server 2000, so I cannot use row_number(). I was going to ask my go to SQL guy, Gregg Stark, how to do ...

Update (24 March 2008): Steve Smith found a more reliable solution to install the SQL Server Client Tools. Once in the tools folder open the setup folder and in there is a SqlRun_Tools.msi file. If you run that it should actually install SSMS. When I recently installed SQL Server 2005 and SQL Server Management Studio on my computer it did not ...

Mark your calendars--the launch date for Visual Studio 2008 (Orcas), SQL Server 2008 and Windows Server 2008 (Longhorn) has been announced. February 27, 2008. In LA, but expect regional events as well, probably filled with free goodies as before. More story at http://www.sqlmag.com/Article/ArticleID/96591/sql_server_96591.html.

I just uploaded my slides and samples for my Programming SQL Server 2005 Reporting Services talk at Microsoft ASP.NET Connections last week in sunny Orlando. This talk focused on programming SSRS using:URL access.SSRS Web Service.SSRS Report Viewer controls.Custom Assemblies You can find the slides and samples at ...

A couple of months ago I finished writing and recording a great new set of self-paced videos on SQL Server 2005 Reporting Services in a partnership with AppDev. A few notes on the course:Over 9 hours of media run time Over 500 pages of printable courseware, but if you prefer we can provide a nicely bound version of the coursebook for a nominal ...