|
|
|
|
Latest Blog Posts
-
|
Everybody enjoys a little free training now and then. I've got mountains of free training in the works. Some of it is in-person and local while some are in webcast format. Please join me as you're able! Tomorrow - Wednesday! Wed, Feb 10, 2010 at 11 am...
|
-
|
In a previous blog post , I had discussed a method of shredding XML to a table with HIERARCHYID, and realized that it had a dependency that I was not too keen about: The XML data required an “id” attribute in order to create the hierarchy. I had sorted...
|
-
|
PowerPivot supports only one type of relationship between two tables, which is the one-to-many relationship. You can define that a column in a table (the “many” side) corresponds to a lookup table through a column which is an identity column there (the...
|
-
|
Sometimes issues pop up with your system. You need a way to find help, quickly. Here’s a few links that might be useful – feel free to post a reply to this post with other sources you might know, from web sources to your favorite consultant. Note – this...
|
-
|
Introduction In SSIS 2005, the Lookup Transformation will fail if it does not find a matching record in the lookup table if configured with the default settings. Build the Data Flow Create a Data Flow Task and add an OLEDB Source. In the OLEDB Source...
|
-
|
In my last post in this series , I talked about the common habit of creating an IDENTITY column on every single table. Today I want to talk about a more broad concept: relying on undocumented (and therefore probably undefined, and certainly far from guaranteed)...
|
-
|
According to T-SQL Tuesday rules as ratified by me in the first and second T-SQL Tuesday posts, the T-SQL Tuesday host is supposed to post a roundup within two days of the end of the event. So a reasonable person should expect a roundup to be posted by...
|
-
|
OK, there are probably a dozen or more of these kinds of posts, but I’ll dive in anyway. From time to time, people send me e-mails or comments on this blog asking for help. Sometimes it’s on the topic at hand, and other times the topic just jogs their...
|
-
|
I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is for the PASS AppDev Virtual Chapter, and will take place on Tuesday at noon EST. You can attend the meeting via this link: https://www323.livemeeting.com/cc/usergroups/join?id=8PQHN2&role=attend...
|
-
|
Introduction This post is the ninth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition...
|
-
|
Hello every body. This is my first blog on that great site so I am really exciting. I have recently met our client who uchecked the sysadmin rights of BUILTIN\Administrators group before given any permissions to another account. That was NOT such problem...
|
-
|
Back in October, I started a series of blog posts called " Bad Habits to Kick ," and thought I would revive the theme. I've worked with developers that dabble in SQL, and they tend to have a few common traits. I'm not sure where they come from, but one...
|
-
|
I think anybody even remotely involved with databases these days has seen the xkcd comic about Bobby Tables : http://xkcd.com/327/ Basically, the comic warns against SQL injection, and reminds you to sanitize your database inputs rather than blindly append...
|
-
|
I'll be presenting at the Northern NJ .NET User Group meeting on Tuesday February 9. Topics we'll cover include: Intro to SQL Server 2008 Integrated Full-Text Search (iFTS) features and functionality, including: Full-text indexes Thesaurus Word breakers,...
|
-
|
In the next month I’ll be speaking at two conferences, one in London, the DevWeek and another one at Neuss, the PASS European Summit. At the DevWeek I’ll deliver a session created explicitly to give developers some insight on SQL Server development, so...
|
-
|
I’ve just released a new script, and now the sys2 scripts are reached the double-digit number: 10! http://sys2dmvs.codeplex.com/ The latest addition is the sys2.tables_columns scripts that helps me to detect which tables uses LOB column so that I can...
|
-
|
Upgrading a database with read-only filegroups Earlier today, I complained that I should be able to upgrade a database with read-only filegroups. In this case an upgrade from, say, 2000 to 2005 is blocked because the engine can't update the system schema...
|
-
|
New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010! The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices. The speaker line-up is growing fast—if you'd like to present,...
|
-
|
On behalf of the 53 MVPs who collaberated on the SQL Server MVP Deep Dives book , I’m pleased to say thank you to the many who have purchased the book. Together we have raised $12,400 for www.warchild.org . If you haven’t yet purchased the book, you should:...
|
-
|
(this post was contributed by Nick Nieslanik, Senior Software Engineer on the MDS team). Many production environments will want to configure Master Data Services (MDS) in a load-balanced Web Farm for scalability and performance reasons. This blog entry...
|
-
|
SQL Saturday is coming to Charlotte next month! If you are in the area, come on by. We have a great line-up of speakers. Find out more information at http://www.sqlsaturday.com/33/eventhome.aspx Share this post: email it! | bookmark it! | digg it! | reddit!...
|
-
|
When one and the same constant is copied and pasted in more than one place, there is always a chance that we can change it in one place and fail to change in another, resulting in a discrepancy. For example, recently I read a very interesting post by...
|
-
|
“Whether you believe you can or you believe you can't, you're probably right.” - Henry Ford Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...
|
-
|
Introduction Andy Warren ( Blog - @sqlAndy ) is a DBA's DBA. He is a friend and mentor. He calls 'em like he sees 'em, and I haven't seen him pull a punch yet. I requested an interview with Andy before I learned of the transfer of SQL Saturday to PASS....
|
-
|
A calculated column is a DAX expression which is evaluated when the PowerPivot workbook is updated. It is very useful, but there are cases where you want to delay calculation at query time. For example: You want to make part of the calculation depending...
|
|
|
|
|
|