Browse by Tags

All Tags » Tips and Tricks (RSS)
07 September 2011 01:37

Advanced reporting services–Slicers - Slides and demos from 24Hrs of Pass session

Here are the files from my Advanced Reporting Services 24 Hours of PASS session on how to put slicers in reporting services. Here is a screen shot of what is possible. One filters the data (Excel style) and the other greys unselected data out (Crescent...
Posted by simonsabin | 3 comment(s)
Filed under: , , ,
26 May 2011 14:49

How to drop all objects since a particular date

If you haven’t accidentally created objects in master then you can’t be developing on SQL. Invariably this happens when you have a DB creation script that has a USE <DB> at the start. If the DB doesn’t exist then you get an error but SSMS just carries...
Posted by simonsabin | 1 comment(s)
Filed under:
17 May 2011 17:48

How to make your laptop 10 times faster

For a while now I’ve been struggling with the performance of my laptop. Over time it starts to run slowly videos play really badly and anything that is CPU bound just takes ages. Anyone thats seen my demos recently might have seen some erratic behaviour...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
05 May 2011 00:14

Working with large XML files in Management Studio

Have you ever tried to generate a large XML file using FOR XML and then found Management Studio die when you try and look at the whole XML document (probably so you can save it). Well the issue is that normally ALL elements and attributes are generated...
Posted by simonsabin | 3 comment(s)
Filed under: ,
27 April 2011 12:59

How to find out when a DB recovery model was changed

A client asked me today how to find out when the recovery model had changed on a DB. The reason was that an overnight process broke because the DB was put into full recovery mode and the transaction log filled up. My initial reaction was that the default...
Posted by simonsabin | 1 comment(s)
Filed under:
01 February 2011 09:28

Solution - Login failed for user x. Reason Token based server access validation failed and error - 18456

Had a very bizarre situation yesterday where a local machine account couldn’t access SQL Server and was getting Login failed for user <user>. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors...
Posted by simonsabin | 3 comment(s)
Filed under: ,
30 January 2011 14:12

Entity framework support for table valued functions and thus full text

One of my most popular posts with over 10, 000 hits is how to enable full text when using LINQ to SQL http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx , core to this is the use of a table valued function...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
29 January 2011 13:11

Performance Tuning and Query Optimisation–SQLBits Training Day

I will be doing a training day at SQLbits in April on Performance Tuning and Query Optimisation. This is the outline for the day. Its going to be an intense day, I look forward to seeing you there. To register go to http://www. sqlbits .com/information...
Posted by simonsabin | 3 comment(s)
Filed under: , , , ,
18 November 2010 21:04

The server principal '<domain>\User' already exists. But it doesn’t

Interesting little situation occurred today, the person I was working with was trying to add a login to a server and was getting the following error. “The server principal '<domain>\User' already exists” They were using a command like this...
Posted by simonsabin | 4 comment(s)
Filed under: ,
03 September 2010 13:04

Great article on costs of query plans

I’ve not seen anyone go into this details before in explaining costing of queries. Whilst I would avoid getting hung up on the specifics of a cost as these will change from release to release. Its a very interesting read about how and why cost optimisation...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
More Posts Next page »