Browse by Tags

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 style) ps the files will be posted after the session...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Sep 7 2011
An annoying problem with Nulls

I just lost half an hour of my life which I'll never get back on this. Don't make the same mistake. I extracted some customer details for a mailing (it's OK, they ticked the box that they want to hear about our special offers) but Marketing complained that some of the address data contained...

Posted to DavidWimbush (Weblog) by DavidWimbush on Thu, Aug 25 2011
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 on in the existing database. This means you...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, May 26 2011
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. I put it all down to the bloat of stuff installed...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 17 2011
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 on ONE line. This means that if you generate a moderately...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, May 5 2011
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 trace should have the information but unfortunately...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Apr 27 2011
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. [CLIENT: <client ip>] along with Error...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Feb 1 2011
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. I’m therefore interested to see that Entity...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Jan 30 2011
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/registration.aspx . Places are limited so make sure...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Jan 29 2011
I love it when a plan comes together

I'm currently working on an application so that our Marketing department can produce most of their own mailing lists without my having to get involved. It was all going well until I got stuck on the bit where the actual SQL query is generated but a rummage in Books Online revealed a very clean solution...

Posted to DavidWimbush (Weblog) by DavidWimbush on Wed, Dec 8 2010

Page 1 of 21 (208 items) 1 2 3 4 5 Next > ... Last »