SqlServerKudos

Tips and Tricks

1
kudos

Kudos

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

published 141 days, 7 hours, 2 minutes ago posted by

sa 150 days, 8 hours, 18 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: PASS, Reporting Services, Tips and Tricks, Training

1
kudos

Kudos

How to drop all objects since a particular date

published 243 days, 15 hours, 3 minutes ago posted by

sa 253 days, 14 hours, 43 minutes ago

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 (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Tips and Tricks

1
kudos

Kudos

How to make your laptop 10 times faster

published 253 days, 15 hours, 48 minutes ago posted by

sa 262 days, 16 hours, 28 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: laptop, Performance, Tips and Tricks

1
kudos

Kudos

Managing multiple remote desktops

published 255 days, 15 hours, 58 minutes ago posted by

sa 264 days, 16 hours, 34 minutes ago

If you work in IT then it is likely that you will be using remote desktop, if your working in operations then you definitely will. Whats more you will be probably connecting to multiple servers at the same time. There are a few tools for managing this...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Administration, Tips and Tricks

1
kudos

Kudos

Working with large XML files in Management Studio

published 265 days, 16 hours, 39 minutes ago posted by

sa 275 days, 16 hours, 19 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Tips and Tricks, XML

1
kudos

Kudos

How to find out when a DB recovery model was changed

published 273 days, 17 hours, 14 minutes ago posted by

sa 282 days, 17 hours, 55 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Tips and Tricks

1
kudos

Kudos

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

published 358 days, 22 hours, 12 minutes ago posted by

sa 368 days, 51 minutes ago

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 (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

tags: Security, Tips and Tricks

1
kudos

Kudos

Entity framework support for table valued functions and thus full text

published 360 days, 22 hours, 21 minutes ago posted by

sa 369 days, 23 hours, 52 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Entity framework, Full Text, LINQ, LINQ To SQL, ORM, Tips and Tricks

1
kudos

Kudos

Performance Tuning and Query Optimisation–SQLBits Training Day

published 360 days, 22 hours, 21 minutes ago posted by

sa 370 days, 57 minutes ago

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...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

tags: Performance, SQLBits, Tips and Tricks, Training, TSQL

1
kudos

Kudos

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

published 434 days, 3 hours, 28 minutes ago posted by

sa 443 days, 6 hours, 8 minutes ago

$The server principal '\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 ' (more)

category: News | clicked: 2 | comment | | source: sqlblogcasts.com

tags: Security, Tips and Tricks

2
kudos

Kudos

Great article on costs of query plans

published 507 days, 9 hours, 35 minutes ago posted by

sa 514 days, 9 hours, 52 minutes ago

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...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Performance, Query Tuning, Tips and Tricks, undocumented

1
kudos

Kudos

Copying large files when running SQL Server

published 520 days, 10 hours, 27 minutes ago posted by

sa 529 days, 13 hours, 6 minutes ago

Copying large files when running SQL Server

Copying large files has always been a pain on a SQL Server as it can result in the OS taking memory from SQL. This is something you don’t want to happen. In the past, and probably still, it can cause What i noticed recently on my windows 7 machine was...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Tips and Tricks

1
kudos

Kudos

Creating a unique constraint on a column that allows nulls

published 545 days, 12 hours, 8 minutes ago posted by

sa 554 days, 14 hours, 52 minutes ago

Creating a unique constraint on a column that allows nulls

Primary keys, unique indexes and unique constraints all enforce uniqueness. The difference between the primary key and the unique index/constraint is that the primary key does not allow any NULL values. However whilst the unique index/constraints do allow...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: SQL Server 2005, SQL Server 2008, Tips and Tricks

1
kudos

Kudos

Report Builder 3.0

published 552 days, 12 hours, 42 minutes ago posted by

sa 561 days, 14 hours, 7 minutes ago

Report Builder 3.0 has some minor additions that make your life a better world. On that i’ve just found is the ability to know what renderer is being used. Why is that useful? Well in all the training I do on Reporting Services I always highlight the...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Report Builder 3.0, reporting, Tips and Tricks

1
kudos

Kudos

Controlling what appears on your tabs

published 556 days, 12 hours, 58 minutes ago posted by

sa 565 days, 15 hours, 38 minutes ago

You can control what appears on your tabs from SQL 2008 onwards. Its still not ideal, IMHO you need to have multi line tabs to show server, database, filename etc. Anyway to control what appears go to Tools | Options and then select the Tec Editor node...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: Management Studio, Tips and Tricks

1
kudos

Kudos

What line does the error line number refer to?

published 561 days, 13 hours, 22 minutes ago posted by

sa 568 days, 14 hours, 48 minutes ago

What line does the error line number refer to?

You’ve got an error and it gives you a line number Msg 50000, Level 16, State 1, Procedure TestToSeeWhatTheErrorLineNumberRefersTo, Line 14 Some Error What line does that actually refer to? Well its the line in the original batch that compiled the procedure...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

tags: Tips and Tricks, TSQL

1
kudos

Kudos

Scream if you want to go faster

published 618 days, 17 hours, 37 minutes ago posted by

sa 625 days, 20 hours, 5 minutes ago

My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlblogcasts.com

tags: PASS, Performance, Query Tuning, SQL Server 2005, SQL Server 2008, Tips and Tricks

1
kudos

Kudos

Avoid SQL Injection with Parameters

published 659 days, 20 hours, 40 minutes ago posted by

sa 669 days, 20 hours, 15 minutes ago

The best way to avoid SQL Injection is with parameters. With parameters you can’t get SQL Injection. You only get SQL Injection where you are building a SQL statement by concatenating your parameter values in with your SQL statement. Annoyingly many TSQL...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: best practice, Security, Tips and Tricks, TSQL

1
kudos

Kudos

Enabling super single user mode with SQL Server

published 670 days, 21 hours, 30 minutes ago posted by

sa 679 days, 21 hours, 59 minutes ago

Enabling super single user mode with SQL Server

I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: SQL Server 2005, SQL Server 2008, Tips and Tricks

1
kudos

Kudos

SSIS - XML Source Script

published 685 days, 22 hours, 35 minutes ago posted by

sa 694 days, 23 hours, 13 minutes ago

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early versions of Biztalk with loaded the whole document into memory to map from one document type to another. This was fine for small documents but was an absolute killer for large documents. You therefore need a... (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: c#, SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tips and Tricks, XML

Welcome!

Tips and Tricks

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

How to drop all objects since a particular date

How to make your laptop 10 times faster

Managing multiple remote desktops

Working with large XML files in Management Studio

How to find out when a DB recovery model was changed

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

Entity framework support for table valued functions and thus full text

Performance Tuning and Query Optimisation–SQLBits Training Day

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

Great article on costs of query plans

Copying large files when running SQL Server

Creating a unique constraint on a column that allows nulls

Report Builder 3.0

Controlling what appears on your tabs

What line does the error line number refer to?

Scream if you want to go faster

Avoid SQL Injection with Parameters

Enabling super single user mode with SQL Server

SSIS - XML Source Script

Open ID Login

Standard Login

Forgot Password?

Sign up