THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server   (RSS)
Showing page 1 of 57 (564 total posts)
  • SQL Saturday in Italy…English version!

    The 2015 is a special year for Italy, because the country hosts Expo 2015, which is the current Universal Exposition. For this reason, the Italian PASS chapter promotes a special edition of SQL Saturday, a free training event for SQL Server professionals. The SQL Saturday #454 in Turin on October 10, 2015 has the following characteristics: ...
    Posted to Davide Mauri (Weblog) by manowar on June 16, 2015
  • 24 Hours of PASS (June 2015)

    The most important free on-line event on SQL Server and Business Intelligence is back! The 24 Hours of PASS is coming back with a great edition that will provide best practices, expert tips, and demos, from new and up-and-coming Speakers. Don't take commitments on 24 and 25 of June 2015. Register now at this link, it's free! No ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on May 27, 2015
  • Data Mining Algorithms – EM Clustering

    With the K-Means algorithm, each object is assigned to exactly one cluster. It is assigned to this cluster with a probability equal to 1.0. It is assigned to all other clusters with a probability equal to 0.0. This is hard clustering. Instead of distance, you can use a probabilistic measure to determine cluster membership. For example, you can ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on May 12, 2015
  • Classic Music, Attractions, and Presentations: Presenting on Database Design at SQL Saturday Atlanta 2015

    This next two weeks are going to be awesome. May 11, I get to see the Who for probably the last time ever. Saturday I am speaking on Database Design at SQL Saturday in Atlanta, then heading to Disney World.  It rarely gets even close to this good for a two week span, and SQL Saturday is a big part of that. I love going to SQL ...
    Posted to Louis Davidson (Weblog) by drsql on May 8, 2015
  • Database Design: 3-State Bits

    I can hear you thinking, “Andy, you’re off your old rocker. There are only two states for bit values!” And you are correct. Almost. What if I’m storing a truly binary value – a value that possesses only two possible states – but there’s the possibility of a third state to indicate that I do not know which state applies. Consider this ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 6, 2015
  • How to rename a column when CDC is enabled

    I have been recently asked if Always On supports metadata operations on tables. The operation is add, drop and column rename. I said that it was possible. However I was informed that during column rename there was an error about “replication”:Caution: Changing any part of an object name could break scripts and stored procedures.Msg 4928, ...
    Posted to Damian Widera (Weblog) by Damian Widera on April 30, 2015
  • Data Mining Algorithms – K-Means Clustering

    Hierarchical clustering could be very useful because it is easy to see the optimal number of clusters in a dendrogram and because the dendrogram visualizes the clusters and the process of building of that clusters. However, hierarchical methods don’t scale well. Just imagine how cluttered a dendrogram would be if 10,000 cases would be shown on ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 17, 2015
  • Data Mining Algorithms – Hierarchical Clustering

    Clustering is the process of grouping the data into classes or clusters so that objects within a cluster have high similarity in comparison to one another, but are very dissimilar to objects in other clusters. Dissimilarities are assessed based on the attribute values describing the objects. There are a large number of clustering algorithms. The ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 28, 2015
  • Off to Richmond for SQL Saturday

    I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the ...
    Posted to Louis Davidson (Weblog) by drsql on March 13, 2015
  • SQLRally Nordic - after conference thoughts

    Hello All I was extremely honored to be able to participate in the SQLRally Nordic this year. The event took place this week in Copenhagen and I think it was a great success - from every angle. Many thanks to the organizers and many thanks to the community for being in that place. There was a great atmosphere during the whole event and what I ...
    Posted to Damian Widera (Weblog) by Damian Widera on March 6, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement