Well done to the SQL Server User Group in Dublin who have organized a great day of SQL server talks taking place on 24th March. This is a community event and free to attend with many of the world top sql experts speaking. More details and registration here Well done all involved.
Category: SQL
SQL Server Express – Profiler
SQL Server Express does not come with a profiler however AnjLab have just released a new version of their great free open source profiler here. Well recommended
Reporting Services – Shared Datasets
Shared datasets which were introduced in Reporting Service 2008 R2 allow a dataset to be shared across reports improving performance and avoiding the typical duplications of common querys and joins you find in most reporting services projects. Like most things in Reporting Services they are pretty easy to use. The following is an example of Read More…
SQL Server Express and Reporting Services
A common question that gets asked is if SQL Serve Express supports Reporting Services. Yes it does however you need to install the version Advanced Services which can be downloaded from here. In addition to the usual restrictions you get with the Express version you can only use Reporting Services against you local express database Read More…
Conditional Formatting in Reporting Services using Common Code
The lack of support for CSS style sheets in reporting services can make life difficult when you want to have common formatting across reports. There are also occasions where you may want to share common conditional formatting logic across reports. This example shows how common code can be used to help in these scenarios. Whilst Read More…
Cork talk on using CLR inside SQL Server
PJ Naughter, a Microsoft MVP, is coming to Cork on April 27 to do a talk on using .NET Common Language Runtime (CLR) inside SQL Server. Register on the mtug web site register
SQL Server Indexing Talk – Niall Flanagan
Niall Flanagan did a great talk to MTUG Cork on indexing and fragmentation in sql server last night. It was a good session and it went on for over two hours with lots of interaction. Well done Niall The materials from the talk can be found on the materials tab on the event Event
SQL Server Express Error 17053
Have not used express for a while and when I when to start the service I got an 17053 error saying could not open master.mdf, etc even though the files exist Solution: Change the service to logon on as system account
Using Select into in Sql server
It’s a No NoDon’t use select into as it locks the tempdb for the duration of the select. You have to create the temp table fist and then do a insert … select … from. Need to look at it this in SQL 2005.