SQLServerCentral / SQLServerCentral.com Announcements / SQLServerCentral.com

CDC for ORacle

Site Owners — Fri, 18 May 2012 13:55:51 GMT

Comments posted to this topic are about the item [B]CDC for ORacle[/B]

SQLServerCentral Member Levels - Updated 2010/06/10

Steve Jones - SSC Editor — Thu, 10 Jun 2010 10:35:41 GMT

Here are the current levels: [code]Forum Newbie 0 Grasshopper 10 SSC Rookie 25 Valued Member 50 SSC Journeyman 75 SSC-Enthusiastic 100 SSC Veteran 200 Old Hand 300 SSC-Addicted 400 Mr or Mrs. 500 500 SSChasing Mays 600 Say Hey Kid 661 Right there with Babe 714 SSC Eights! 800 Ten Centuries 1,000 Default port 1,433 UDP Broadcaster 1,434 SSCommitted 1,500 SSCrazy 2,000 Hall of Fame 3,000 SSCarpal Tunnel 4,000 SSCertifiable 5,000 SSCrazy Eights 8,000 SSChampion 10,000 SSCoach 15,000 SSC-Insane 20,000 One Orange Chip 25,000 SSC-Dedicated 30,000 SSC-Forever 40,000 SSC Guru 50,000[/code]

New PowerPivot Forum

Steve Jones - SSC Editor — Tue, 15 Nov 2011 10:14:41 GMT

We have a new forum here for all PowerPivot questions: [url]http://www.sqlservercentral.com/Forums/Forum3053-1.aspx[/url]

2011 SSC Code for PASS Summit

Clayton Lohm — Thu, 10 Mar 2011 10:17:23 GMT

I know it's kind of early, but we want to register now to take advantage of the early bird rate. Can anyone tell me what the registration code for SQL ServerCentral is for this year?

Database Size Survey

Site Owners — Fri, 01 Jul 2011 00:05:30 GMT

Comments posted to this topic are about the item [B]Database Size Survey[/B]

Cartoonists Wanted

Site Owners — Thu, 26 May 2011 22:52:53 GMT

Comments posted to this topic are about the item [B]Cartoonists Wanted[/B]

SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process

Site Owners — Mon, 25 Jul 2011 12:08:16 GMT

Comments posted to this topic are about the item [B]SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process[/B]

Author Guidelines

Site Owners — Fri, 14 May 2010 15:32:36 GMT

Comments posted to this topic are about the item [B]Author Guidelines[/B]

CSS Changes

Steve Jones - SSC Editor — Wed, 22 Jun 2011 10:29:05 GMT

A few changes to the CSS today. One was to raise the line height, and hopefully make articles easier to read. The other was a change to code blocks that should fix some IE formatting (tall blocks).Please report any issues.

The Vermillion Screen of Death (Raw Materials Comic Strip)

Site Owners — Wed, 11 Mar 2009 00:19:05 GMT

Comments posted to this topic are about the item [B]The Vermillion Screen of Death (Raw Materials Comic Strip)[/B]

Happy Memorial Day

Site Owners — Sat, 28 May 2011 15:37:24 GMT

Comments posted to this topic are about the item [B]Happy Memorial Day[/B]

Rebuild Master

Site Owners — Tue, 22 Apr 2008 00:15:05 GMT

Comments posted to this topic are about the item [B]Rebuild Master[/B]

2010 SSC Code for PASS Summit

NULLgarity — Wed, 13 Jan 2010 12:33:56 GMT

It's early, but I'm registering to take advantage of early bird rate. Anyone know if the registration code for SQL Server Central is SSC?

Database Mirroring DMV

Site Owners — Tue, 10 Jun 2008 21:56:06 GMT

Comments posted to this topic are about the item [B]Database Mirroring DMV[/B]

Graphical Query Plans

Site Owners — Tue, 19 Feb 2008 23:45:58 GMT

Comments posted to this topic are about the item [B]Graphical Query Plans[/B]

Raw Materials - The Decision

Steve Jones - SSC Editor — Thu, 16 Sep 2010 09:10:33 GMT

I was told recently that the [url=http://www.sqlservercentral.com/tags/Raw+Materials]Raw Materials comics [/url]that we have run for a little over a year, will be be discontinued recently. This wasn't my decision, but honestly I can understand the decision and didn't fight it. Phil Factor was the person that brought this idea forward, and has worked with Larry Gonick to bring you a steady stream of comics that have entertained many people, myself included, over the last year or so. A few weeks ago one of the senior management people at Red Gate asked about the cost for the comics and did not feel that the cost of the comics was in line with the exposure and the reads that they got. This is not to say that Mr. Gonick is charging too much, as I have no idea what a good rate is for a comic. This is more that the cost of the comics, compared with what we see in our web analytics isn't a good return from management's point of view.This isn't necessarily a final decision, but more an immediate one. If you think that the comics are worth continuing, then I'd urge you to pass the word to friends, get more people to view older comics, and write a letter to Red Gate. You can contact them at info@red-gate.com, and explain why the comics are a great idea.If there is enough response, I'm sure we can continue this series.

WAITFOR

Site Owners — Mon, 16 Jun 2008 20:53:18 GMT

Comments posted to this topic are about the item [B]WAITFOR[/B]

CLR Assemblies

Site Owners — Wed, 18 Jun 2008 21:52:49 GMT

Comments posted to this topic are about the item [B]CLR Assemblies[/B]

Part 3 link broken

Anthony Young-223234 — Thu, 30 Sep 2010 12:33:32 GMT

the stairway to StreamInsight article includes a link to part 3 of the series - [url=http://www.sqlservercentral.com/articles/StreamInsight/70160/]StreamInsight - The Development Models[/url] but that link just takes me to an error page.

Stairway to SSRS

Site Owners — Wed, 25 Aug 2010 16:55:24 GMT

Comments posted to this topic are about the item [B]Stairway to SSRS[/B]

Execution Plans

Site Owners — Sat, 16 Feb 2008 13:14:00 GMT

Comments posted to this topic are about the item [B]Execution Plans[/B]

Index Seeks

Site Owners — Wed, 20 Feb 2008 21:29:49 GMT

Comments posted to this topic are about the item [B]Index Seeks[/B]

Rebuild Master

Site Owners — Wed, 30 Apr 2008 22:19:23 GMT

Comments posted to this topic are about the item [B]Rebuild Master[/B]

Stairway to Database Design

Site Owners — Tue, 04 May 2010 10:46:30 GMT

Comments posted to this topic are about the item [B]Stairway to Database Design[/B]

Stairway to StreamInsight

Site Owners — Tue, 04 May 2010 14:09:24 GMT

Comments posted to this topic are about the item [B]Stairway to StreamInsight[/B]

Decoding the SQL Server Index Structure

Site Owners — Wed, 31 Mar 2010 22:08:44 GMT

Comments posted to this topic are about the item [B]Decoding the SQL Server Index Structure[/B]

Stairway to StreamInsight

Site Owners — Mon, 15 Mar 2010 10:03:34 GMT

Comments posted to this topic are about the item [B]Stairway to StreamInsight[/B]

Beta - New Search Engine

Steve Jones - SSC Editor — Fri, 30 Oct 2009 09:31:34 GMT

We have rolled out a new search engine on our beta site. ([url=http://beta.sqlservercentral.com]beta.sqlservercentral.com[/url])Please try it out and give us feedback in this thread.

The 2009 SQLServerCentral party at the PASS Summit

Site Owners — Sat, 18 Jul 2009 19:46:01 GMT

Comments posted to this topic are about the item [B]The 2009 SQLServerCentral party at the PASS Summit[/B]

ASK SQLServerCentral

Steve Jones - SSC Editor — Fri, 09 Oct 2009 09:10:33 GMT

We have set up a new "ask" site based on the StackOverflow codebase at [url]http://ask.sqlservercentral.com[/url].Please feel free to ask/answer questions there. Right now this is a hosted system and I do not know how we will get points / score/ reputation sync'd up, but if you keep your username the same at the ask site, we will determine some way to do this. We might also move to an OpenID system here at some point.

ASK SSC Announcement

Site Owners — Sat, 17 Oct 2009 02:55:32 GMT

Comments posted to this topic are about the item [B]ASK SSC Announcement[/B]

New Code formatting engine rolled out

Ben Adderson — Mon, 28 Sep 2009 02:50:42 GMT

We've now updated the syntax highlighting here on the forums. We've also tweaked the IFCodes to try and clarify which should be used for what. The revised list of tags are as follows:[ code ] - Will default to SQL highlighting[ code ="sql" ] - SQL highlighting[ code ="xml" ] - XML highlighting[ cpde="vb" ] - VB highlighting[ code ="other" ] - Any other code you'd like highlighted. This option relies on the highlighter to determine the language, so YMMV. As we're using Google Code Prettify, you can find more details on the supported languages [url=http://google-code-prettify.googlecode.com/svn/trunk/tests/prettify_test.html]here[/url][ code ="plain" ] - This option just provides a fixed font, for when you don't want syntax highlighting, or the "other" option is not satisfactory.I've updated the IFCode Shortcuts, so the new Codes should appear in the list when you're composing a post.Here are some (pretty vanilla) examples from me, using the new Codes:Using [ code ]:[code]SELECT *FROM CustomersWHERE CustomerId = 123456[/code]Using [ code="sql" ][code="sql"]SELECT *FROM CustomersWHERE CustomerId = 123456[/code]Using [ code="xml" ][code="xml"]<xml><customer id="123456"><name>John Doe</name></customer></xml>[/code]Using [ code="vb" ][code="vb"]Imports SystemClass [class] Shared Sub [shared](ByVal [boolean] As Boolean) If [boolean] Then Console.WriteLine("true") Else Console.WriteLine("false") End If End SubEnd ClassModule [module] Sub Main() [class].[shared](True) ' This prints out: ". Console.WriteLine("""") ' This prints out: a"b. Console.WriteLine("a""b") ' This prints out: a. Console.WriteLine("a"c) ' This prints out: ". Console.WriteLine(""""c) End SubEnd ModuleDim d As Dated = # 8/23/1970 3:45:39AM #d = # 8/23/1970 #d = # 3:45:39AM #d = # 3:45:39 #d = # 13:45:39 #d = # 13:45:39PM #Dim n As Floatn = (0.0, .99F, 1.0E-2D, 1.0E+3D, .5E4, 1E3R, 4D)Dim i As Integeri = (0, 123, 45L, &HA0I, &O177S)[/code]Using [ code="other" ][code="other"]public class HelloWorld(){ public static void main(string[] args) { Console.Writeline("Hello World!") }}[/code]Using [ code="plain" ][code="plain"]public class HelloWorld(){ public static void main(string[] args) { Console.Writeline("Hello World!") }}[/code]I've created this new thread (rather than post in [url=http://www.sqlservercentral.com/Forums/Topic677710-83-1.aspx]this old one[/url]) so we can keep track of any issues/bugs with the new engine. If you run into any problems, please let us know by posting them here!Thanks!

Code Formatting

Steve Jones - SSC Editor — Tue, 17 Mar 2009 11:12:07 GMT

New code formatting has been released on SSC. Please feel free to check it out and comment.Use the [ code ][ /code ] shortcuts to the right for enclosing code items.

User Name Change

Steve Jones - SSC Editor — Wed, 16 Sep 2009 09:31:31 GMT

We have deployed our changes to the user names. If you now have a number after your name, that is because you had a duplicate name with someone else. The first person who registered with the name gets to keep it.Please contact the webmaster if you have questions.

Reporting Services Forum Changes

Steve Jones - SSC Editor — Mon, 31 Aug 2009 11:36:56 GMT

I had a suggestion to separate out SSRS 2005 and SSRS 2008 forums. Since most of the questions in the current forums related to SSRS 2005, I have renamed them 2005 forums, and added 2008 copies.

Improving Site Navigation

Mel Harbour — Tue, 25 Aug 2009 02:47:25 GMT

Hi all,One of the things that we're looking into at the moment involves ways in which we can improve the site navigation. I mean this in the broadest possible sense of the word navigation. Currently, (as you may be aware), articles are tagged by authors/administrators, and a navigation system is created using these tags. We also display some of the most recent, and most popular articles (with popularity biased towards recently popular rather than popular for all time) on the homepage.Finally, when you actually view an article, it will generally offer you some links to so-called 'related' content, in two sections, one near the top of the article, and the other near the end of the article.There is also a search (Google custom search).What we'd like to do is try and gather some feedback from you, the site users, on what you like, what you don't like and how we might be able to improve the site for you so that you can get straight to the content you want/need, as well as creating a good experience for first time visitors to the site (recognising that long time site users probably use the site slightly differently).A few topics you might like to consider to get you started:[ul][li]Do you like articles being categorised? Is the current categorisation any good? How could it be improved?[/li][li]Do you ever browse for articles on the site, or are you usually trying to find a specific topic?[/li][li]Are related content links relevant?[/li][li]Do you think that users would help improve the 'related content' information?[/li][li]Does the search return relevant results for you (particularly when you know that a given article exists somewhere!)?[/li][/ul]Obviously, we internally have some of our own opinions already formed on these sort of things, but we're keeping a pretty open mind. If you've got examples of a sort of navigation that would work well, let us know and we'll put the ideas into the mix!Mel

SQLServerCentral Editorial Policy - Article Publication

Steve Jones - SSC Editor — Tue, 11 Aug 2009 08:27:51 GMT

I think it's time I just made a post for this and made it available for everyone to see. Actually it probably deserves an editorial as well that might explain it better.A number of complaints have been issued at various times from "experts" or knowledgeable SQL professionals that the information we publish is inaccurate or dangerous. I'll admit that we have published things that are inaccurate. Everyone has, including many experts. Some of them pull down information, some don't. Some don't realize that it's there, some do. It's a problem in any publication business.As far as things being dangerous, I am torn here. We can't control how people do things, and I would rather have the information out there along with the discussion than hide it. Do we never publish anything on cursors? or CLR manipulation of data that can be done better in T-SQL? The user has to beware, and that includes learning about something before you use it.Now that I've rambled, here's the basic policy.I look to publish articles that can be read, and have some technical information in them. We try to avoid white papers/marketing papers, but otherwise, I think if it's technical and written about SQL Server, we try to put it out there. We correct grammar and spelling as best we can, and make mistakes there at times, but our goal is to get information out there and debate it.I will let authors know when I disagree, or think they have made a mistake, but I don't censor articles. I certainly realize that I'm not always right, and perhaps I've missed something they haven't. But if they insist that something is a good way to solve a problem, I am willing to let them put it out there and have the community judge it.We are not trying to be the final authority on how SQL Server works, but rather a wide publication on how the product us used, and sometimes mis-used, in the real world. The goal is to build a community that helps each other.

Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008

Site Owners — Sun, 09 Aug 2009 07:25:35 GMT

Comments posted to this topic are about the item [B]Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008[/B]

Site Issues - July 9 2009

Site Owners — Wed, 15 Jul 2009 14:17:47 GMT

Comments posted to this topic are about the item [B]Site Issues - July 9 2009[/B]

Issues with Code tags...

Luke L — Fri, 10 Jul 2009 13:03:32 GMT

Thanks for the new code tags, I did notice one that has nothing to do with Cut and Paste.Perhaps it's just my browser or my language settings, but when I use the IFCode Shortcuts for code="sql" or xml instead of [code=”sql”][/code]. The double quotes are coming across as ASCII(148) instead of ASCII(34). When I tried to use it with the ”(148) quotes it did not work. When I changed them to "(34) it did.Also, any chance you could make it accept sql or SQL? it seems to not like it if it's upper case.And error message that states could not find brush for SQL appears if you use the below.code="SQL"Thanks and keep up the good work.-Luke.Edit: in case you're wondering I'm using FF 3.0.11 with Unicode UTF-8 character encoding...