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 » Development   (RSS)
Showing page 1 of 2 (20 total posts)
  • How to calculate barcode check-digit using T-SQL language

    Introduction In order to scale, it's imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to customers efficiently? The answer is: Barcode! A barcode is the graphical representation of a sequence of numbers and other symbols. The representation is made by lines (bars) and spaces. A barcode ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 23, 2017
  • PASS AppDev next webinar: “Introducing R”

    On May 25th the PASS Application Development Virtual Group will host a new webinar delivered by the well know Dejan Sarka and the topic will be R (https://www.r-project.org/) that is more and more used also by developers: Introducing R R is a free software programming language and software environment for statistical computing, data mining, ...
    Posted to Davide Mauri (Weblog) by manowar on May 4, 2017
  • PASS AppDev Recording: “Building REST API with SQL Server using JSON functions”

    Last week Jovan Popovic (SQL Server Program Manager for JSON support and other nice things) delivered a very interesting webinar on JSON and SQL Server / Azure SQL for the PASS Application Development Virtual Group. If you’re interested in the subject, here’s a couple of links that will make you happy: Full recording is on PASS Development ...
    Posted to Davide Mauri (Weblog) by manowar on April 30, 2017
  • PASS Application Development Virtual Group

    I've been involved with PASS, once named Professional Association of SQL Server users, now just...PASS, since 2006 when I stepped up as president of SQL Server Italian User Group. Now that I moved to Redmond, WA, I'm still involved with it, but of course, I'm not leading the Italian User Group anymore. Since I do really think that community ...
    Posted to Davide Mauri (Weblog) by manowar on April 11, 2017
  • The biggest table in your database

    You may need to know which is the biggest table (in terms of disk space usage) in the database that you are currently connected. Sometimes, this information is very useful to check the indexing strategy of these tables. There are several methods to know which is the biggest table of a database, one of these methods is to use the standard ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 11, 2016
  • The free #eBooks series #SQLServer and .NET Blog

    The series of free eBooks ''The SQL Server and .NET Blog eBook Series'' by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase AdministrationPerformance Tuning Developing SQL Server (The SQL Server and .NET eBook Series)This ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 16, 2015
  • How In-Memory Database Objects Affect Database Design: Hybrid Code

    In my first attempts at building my code, I strictly went with either native or on-disk code. I specifically wrote the on-disk code to only use features that worked in-memory. This lead to one majorly silly bit of code, used to create system assigned key values. How would I create a customer number that was unique. We can’t use the Max(value) + 1 ...
    Posted to Louis Davidson (Weblog) by drsql on August 8, 2014
  • One more reason to to understand query plans, not directly performance related

    One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming languages, it is very obvious what is going on inside the computer because you are working at a very low level. For example, if you are a C/C++ programmer writing an OS, you will know a lot ...
    Posted to Louis Davidson (Weblog) by drsql on January 22, 2013
  • Utility Queries–Structure of Tables with Identity Column

    Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function to using sys.tables. When writing code that is expected to have reuse, it can be safer to use the tables rather than functions because the tables will work in the context of the database that is in the from ...
    Posted to Louis Davidson (Weblog) by drsql on September 2, 2012
  • Normalization and How to Know When You Are Done… The short version…

    A while back, I was working on a short article about Normalization for a book that never got published (admittedly I wasn’t getting paid for the article, and it wasn’t for charity, so I wasn’t that broken up over it.)  The task at hand was to, in 2 pages or less, describe the process of normalization and help you to know when you have ...
    Posted to Louis Davidson (Weblog) by drsql on May 29, 2011
1 2 Next >
Privacy Statement