|
|
|
|
Got a SQL Server question that needs answering? SQLblog now has a SQL Server forum that can be found at http://sqlblog.com/forums/57/ShowForum.aspx.
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...
|
There are
360 guest(s) online.
There are 1 of 9,012 member(s) online
- clydedoggie
|
|
|
|
|