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 2 of 57 (570 total posts)
  • 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
  • Data Mining Algorithms – an Introduction

    Data mining is the most advanced part of business intelligence. With statistical and other mathematical algorithms, you can automatically discover patterns and rules in your data that are hard to notice with on-line analytical processing and reporting. However, you need to thoroughly understand how the data mining algorithms work in order to ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 19, 2015
  • T-SQL Querying

    We are close to the publishing day of the T-SQL Querying book. Of course, like always in this series, the main author of the book is Itzik Ben-Gan. This time, besides me, Adam Machanic and Kevin Farlee are the coauthors. The information I want to share now is that you can get a substantial discount if you preorder the book today, Monday, February ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 16, 2015
  • SQL Server 2012 SP2 Cumulative Update 4 Released - information from the SQL Server SE Operations Team

    As per information from Microsoft: ''It is my pleasure to announce the release of SQL Server 2012 SP2 Cumulative Update 4 on behalf of the team.  SQL Server 2012 SP2 Cumulative Update 4 incorporates 42 issues. This CU will be available for download from the associated cumulative KB article that has also been ...
    Posted to Damian Widera (Weblog) by Damian Widera on January 20, 2015
  • Getting Started with SSIS: Get the Software and Tools

    People often ask me for tips on getting started with SSIS. My advice is always the same: Get a copy of SQL Server Developer Edition. At the time of this writing, the current version of SQL Server is SQL Server 2014. If you work in an organization that uses SQL Server, you may be able to obtain a copy of SQL Server 2014 Developer Edition from ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 1, 2015
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement