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 » T-SQL   (RSS)
Showing page 6 of 13 (126 total posts)
  • 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
  • Using Composable DML to maintain entity history [T-SQL]

    I recently inherited a data warehousing SQL Server solution from my good buddy James Rowland-Jones (you may know him from his more auspicious role on the SQLPass board) and it contained a very cool technique of using composable DML (a feature that arrived in SQL Server 2008) to maintain history of updates to a particular table. I knew about ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 13, 2012
  • Speaking at PASS 2012… Exciting and Scary… As usual…

    Edit: As I reread this, I felt I should clarify.. As usual refers mostly to the ''Scary'' part. I have a lot of stage fright that I have to work through. And it is always exciting to be picked.   I have been selected this year at the PASS Summit 2012 to do two sessions, and they are both going to be interesting. Pre-Con: Relational ...
    Posted to Louis Davidson (Weblog) by drsql on June 23, 2012
  • Bitmask data insertions in SSDT Post-Deployment scripts

    On my current project we are using SQL Server Data Tools (SSDT) to manage our database schema and one of the tasks we need to do often is insert data into that schema once deployed; the typical method employed to do this is to leverage Post-Deployment scripts and that is exactly what we are doing. Our requirement is a little different though, our ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 11, 2012
  • DATEFROMPARTS

    I recently overheard a remark by Greg Low in which he said something akin to ''the most interesting parts of a new SQL Server release are the myriad of small things that are in there that make a developer's life easier'' (I'm paraphrasing because I can't remember the actual quote but it was something like that). The new DATEFROMPARTS ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 10, 2012
  • Utility Queries–Column Metadata

    Very often, I find myself wanting to query system metadata for columns. Some of the metadata is fairly easy to deal with, like if you want to find column names, just simply querying sys.columns is very straightforward.  But if you want to query data types, it gets stickier.  There are type types listed, one that is the declared type, and ...
    Posted to Louis Davidson (Weblog) by drsql on April 22, 2012
  • Microsoft Delivers Full Suite of SQL Server PowerShell Cmdlets

    We’ve all been waiting several years for this, and finally it’s here! Coinciding (approximately) with the release of SQL Server 2012, a new Feature Pack has appeared on the Microsoft web site that adds a full suite of PowerShell cmdlets for DDL and other functions. This means that, at last, we can do things like fully-featured SQL deployment ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on April 1, 2012
  • Use VALUES clause to get the maximum value from some columns [SQL Server, T-SQL]

    My ex-colleague Paul Mcmillan pointed me at a thread on Stack Overflow that demonstrated a neat T-SQL trick to get the maximum value from a collection of columns in a row. Paul had never seen it before and neither had I so I figure one or two of you out there might learn something from it too. In short you can use the VALUES clause to effectively ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 20, 2012
  • Server level permissions for developers–why you should read books

    It is quite difficult recently for me to find some time to write a new post, so I don’t seem to be leading the rankings of the most frequent bloggers. I rarely recently have opportunity to lay my hands on the code too, so natural sources of ‘inspiration’ are less often. Hopefully this will change in 2012 and I will have more opportunities to write ...
    Posted to Piotr Rodak (Weblog) by rodak.p@gmail.com on January 1, 2012
  • T-SQL Tuesday 24: Ode to Composable Code

    I love the T-SQL Tuesday tradition, started by Adam Machanic and hosted this month by Brad Shulz. I am a little pressed for time this month, so today’s post is a short ode to how I love saving time with Composable Code in SQL. Composability is one of the very best features of SQL, but sometimes gets picked on due to both real and imaginary ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 8, 2011
« First ... < Previous 4 5 6 7 8 Next > ... Last »
Privacy Statement