• New Azure Mobile Services Samples

    Updated: 2013-01-11 04:15:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in The Bit Bucket Greg Low IDisposable Entire Site Search Home Blogs Downloads Opml The Bit Bucket Greg Low IDisposable Ramblings of Greg Low SQL Server MVP , MCM and Microsoft RD SQL Down Under New Azure Mobile Services Samples Hi , Folks I have to say that I’m really impressed by the rate at which the Windows Azure Mobile Services team is rolling out updates and samples . In particular , it’s good to see a new sample for using Geolocation , given how common a requirement that is in mobile apps today . It’s worth checking out the : following New Code Samples page on WindowsAzure.com Updated WindowsAzure.com Tutorials and Resources page that includes new tutorials and related videos from

  • SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 3

    Updated: 2013-01-11 01:30:34
    Before you start reading this blog post, I strongly suggest you to read the part 1 of this series.It talks about What is Redundant Index. The story is a conversation between two individuals – Jon and Mike. They are different but have single goal learn and explore SQL Server. Their initial conversation sets the ground [...]

  • The client code that handles timeouts

    Updated: 2013-01-10 21:05:00
    After timeouts we need to make sure that active transactions, if any, are rolled back. All timeout handling must be done on the client. This post provides the implementation and unit tests. Implementation The following class extends SqlCommand and rolls back active transactions after timeouts: public static class SqlCommandExtentions { public static void ExecuteNonQueryWithErrorHandling ( this SqlCommand command ) { try { command.ExecuteNonQuery (); } catch ( SqlException e ) { HandleSqlException...(read more)

  • From Zero To SSIS Training: 4-8 Mar 2013 in Reston Virginia

    Updated: 2013-01-10 16:00:00
    Want to learn more about SSIS? I  can help. In my course - From Zero To SSIS – I teach you how to effectively use SSIS to deliver data integration solutions. This is not a market-y survey of the bells and whistles contained in SSIS. I focus on the tasks data integration and ETL developers will use to produce SSIS packages in the enterprise. How do I know which tasks are used most? I have been using SSIS since the early beta versions. For over two years, I managed a team of ETL developers at...(read more)

  • SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore

    Updated: 2013-01-10 01:30:37
    Here are a few things that I hear very often: I already have a SharePoint administrator, and I don’t need a database expert.  Or, my database is already configured because we already have SharePoint installed on its default settings.  Or, Microsoft has told us not to touch the SharePoint database.  All these things may be [...]

  • Get to Know SQL Server 2012's SQL Server Data Tools [article published]

    Updated: 2013-01-09 23:12:03
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London Get to Know SQL Server 2012's SQL Server Data Tools article published I recently wrote an article on SQL Server Data Tools for SQL Server Magazine and it has now been published online at Get to Know SQL Server 2012's SQL Server Data Tools In the article I offer my thoughts and opinions on SQL Server Data Tools as it exists in SQL Server 2012. Note that the article refers to SSDT database projects only , there is nothing in there pertaining to SSIS , SSAS or SSRS . If you find that confusing then you should probably go and at least read the

  • After the timeout

    Updated: 2013-01-09 18:23:00
    After the timeout, we may sometimes, but not always, end up with an outstanding transaction. If this is the case, we need to rollback the transaction ourselves. Otherwise the consequent commands which use the same connection might not work as expected. Let us debug through some client code and see what is happening in more detail. Prerequisites We shall need a few database objects, as follows: CREATE TABLE dbo.Log1 ( InTran VARCHAR ( 20 )); GO CREATE PROCEDURE dbo.TestTran AS BEGIN IF @@TRANCOUNT...(read more)

  • SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani

    Updated: 2013-01-09 01:30:50
    Balmukund Lakhani (Blog | Twitter | Site) is currently working as Technical Lead in SQL Support team with Microsoft India GTSC. In past 7+ years with Microsoft he was also a part of the Premier Field Engineering Team for 18 months. During that time he was a part of rapid on-site support (ROSS) team. Prior to joining Microsoft in 2005, [...]

  • HDDs, SSDs and Database Considerations

    Updated: 2013-01-09 00:00:00
    In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work and looks into the considerations every DBA should have in mind when choosing / working with SSDs.

  • Microsoft Windows Azure Disaster Recovery Options for On-Premises SQL Server

    Updated: 2013-01-08 14:40:48
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Buck Woody Entire Site Search Home Blogs Downloads Opml Buck Woody Carpe Datum Microsoft Windows Azure Disaster Recovery Options for On-Premises SQL Server One of the use-cases for a cloud solution is to serve as a Disaster Recovery option for your on-premises servers . I'll explain one particular use-case in this entry , specifically using Windows Azure IaaS or Virtual Machines as a Recovery Solution for SQL Server more detail here : http : www.windowsazure.com en-us home features virtual-machines In future installments I'll explain options for other workloads such as Linux and Windows Servers , SharePoint and other solutions . Some architectures also allow for using Windows Azure SQL

  • SQL Server – Using SSMS Commandline Parameters – Guest Post by Vinod Kumar M

    Updated: 2013-01-08 01:30:25
    Vinod Kumar M is my very good friend renowned SQL Server Expert. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a [...]

  • SQLAuthority News – Register for NuoDB the Elastically Scalable, SQL/ACID Database

    Updated: 2013-01-08 01:30:09
    If you are reading this blog, you will be familiar with the innovative database product NuoDB, which I have been experimenting recently. I have been working with this product since last year. I got my hand’s on this product when the product was in its very early phase as well, the product was yet to be [...]

  • Statistics in SQL Server

    Updated: 2013-01-08 00:00:00
    SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or missing then you have little realistic hope of having queries that perform well. It is therefore important to appreciate how SQL Server maintains distribution statistics.

  • Power Pivot SQL Agent Job Monitor

    Updated: 2013-01-07 21:23:29
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Davide Mauri Entire Site Search Home Blogs Downloads Opml Davide Mauri A place for my thoughts and experiences on SQL Server , Business Intelligence and NET Power Pivot SQL Agent Job Monitor In the last days I needed a quick and efficient way to monitor the performance of a job and of each step over time . There’s a lot of interesting data in MSDB database and the various sysjob tables , but the stored data is not really easy to use outside the Management Studio . Date and Time are not stored as date time data type , there is no easy way to correlate the performance of a step with the related job execution for example is not that easy to return all the steps of a job executed , say ,

  • SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2

    Updated: 2013-01-07 01:30:27
    Before you start reading this blog post, I strongly suggest you to read the part 1 of this series. It talks about What is Redundant Index. The story is a conversation between two individuals – Jon and Mike. They are different but have single goal learn and explore SQL Server. Their initial conversation sets the [...]

  • Diversion: Sub-Second SQL Sudoku Solver

    Updated: 2013-01-06 19:46:00
    I enjoy Sudoku as a way to relax on occasion but, being an IT guy, I suppose I am predictably meta: solving them is fun, but making a machine to solve them is even more fun. I created a clunky solver once before based on the idea of using as few T-SQL statements as possible. This year I decided to try to make a fast solver instead. It’s working fairly well and solves most puzzles in under a second on my laptop. It helps I’ve been sick with a cold for the past two weeks, giving me the sort of “enforced...(read more)

  • SQLAuthority News – Download Whitepaper – Cleanse and Match Master Data by Using EIM

    Updated: 2013-01-06 01:30:43
    Master Data Services (MDM) and Data Quality Services (DQS) go hand to hand together when they have to maintain the integrity of the database. If you are new to either of concept I suggest you to read following two articles to get an idea about them. Why Do We Need Master Data Management: MDM was [...]

  • Analyzing Complexity of Text

    Updated: 2013-01-05 18:32:15
    Storing text in a database is common. What isn’t common is needing to know the reading ease and grade level of the text, but I was presented such a requirement (actually it was more of a wish list item) this week. There are ways of solving this problem. In my conclusion, I outline the steps for implementing T-SQL code to estimate reading complexity. I think the topic of reading ease and grade level ratings is potentially of greater general interest than you might at first think. For example, you...(read more)

  • SQL SERVER – Weekly Series – Memory Lane – #010

    Updated: 2013-01-05 01:30:51
    Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]

  • MCM – I passed!

    Updated: 2013-01-04 23:40:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Rob Farley Entire Site Search Home Blogs Downloads Opml Rob Farley Rob Farley Owner Principal with LobsterPot Solutions a MS Gold Partner consulting firm Microsoft MVP SQL Server and leader of the SQL User Group in Adelaide , Australia . Rob is also a Director of PASS , and runs training courses around the world in SQL Server and BI . topics MCM I passed I was wrong I passed the MCM lab last . month I know I thought I’d failed I’m still surprised that I passed . Maybe I managed to satisfy enough of enough questions . Certainly none of the questions were beyond me , as I wrote just after I’d sat it But I do know that I left more questions in an incomplete state than I would’ve . liked

  • “Add as object” or “Add as script”? [SSDT]

    Updated: 2013-01-04 14:15:46
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London Add as object” or Add as script” SSDT In SQL Server Data Tools SSDT one way to create a new object is to right click on a folder in Solution Explorer and point to Add . Doing so will display this : menu A number of options are offered for creating a brand new object function” , table” , stored proc” etc and one of them is Script” . If your preference is to handcraft the DDL for every database object without resorting to a GUI then you may choose to use the Script” option because , after all , every file is just a DDL script why not write

  • Microsoft advocates checkpoints - proceed with caution [SSIS]

    Updated: 2013-01-04 13:28:15
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London Microsoft advocates checkpoints proceed with caution SSIS In December 2012 Microsoft published a whitepaper entitled SSIS Operational and Tuning Guide which you can download by clicking here I have skimmed through the whitepaper and it appears to be a compelling read however a couple of sentences caught my eye that I want to draw attention to here . These sentences refer to the use SSIS checkpoint : files Some of the most common challenges with SSIS packages are in how to handle unexpected failures during execution , and how to minimize the

  • Creating a Custom SSIS 2012 Task Series

    Updated: 2013-01-04 13:00:00
    A while back I asked myself: “Self, do you think it is possible to create a custom SSIS 2012 task using Visual Studio 2012 Express?” That question launched a quest to learn the answer. In this series of posts I describe what I learned: Creating a Custom SSIS 2012 Task – The Rambling Introduction Creating a Custom Task in SSIS 2012 – Getting Started Creating a Custom Task in SSIS 2012 – Configuring the Project Creating a Custom SSIS 2012 Task – Signing the Assembly Creating a Custom SSIS 2012 Task...(read more)

  • SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1

    Updated: 2013-01-04 01:30:21
    Index never stops amazing me, there are so much to learn about Index that I never feel that there is enough knowledge out about this subject. If you are interested you can watch my Indexing Course on Pluralsight for further learning on this subject. Instead of going on the theory overload – let us start [...]

  • How full is my Windows Azure SQL Database?

    Updated: 2013-01-03 02:58:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in The Bit Bucket Greg Low IDisposable Entire Site Search Home Blogs Downloads Opml The Bit Bucket Greg Low IDisposable Ramblings of Greg Low SQL Server MVP , MCM and Microsoft RD SQL Down Under How full is my Windows Azure SQL Database While the level of compatibility of Windows Azure SQL Databases is high , there are a number of things that need to be dealt with differently , compared with how they are done with on-premises SQL . Server An example of this , today I needed to know how full one of my databases was . I wanted to know how much space I had used but also to know what the limit was . My first attempt was the usual system views such : as SELECT FROM sys database_files But in

  • SQLAuthority News – Year 2012 in Review – Perspective of Blog

    Updated: 2013-01-03 01:30:07
    The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Crunchy numbers: 3,200,000 people watched the Mars Rover land. This blog was viewed about 19,000,000 times in 2012. If this blog were a video of the Rover landing, it would take about 6 days for that many people to see it. In 2012, there [...]

  • Warning! Publish may fail on creation of a FOREIGN KEY constraint and then immediately succeed [SSDT]

    Updated: 2013-01-03 00:15:06
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London Warning Publish may fail on creation of a FOREIGN KEY constraint and then immediately succeed SSDT I have stumbled across a nuance of SSDT that other users should be cognizant of . I published an SSDT database project onto an existing database that already had data in it but that Publish operation : failed The error message : was 10036,1 SQL72014 : Net SqlClient Data Provider : Msg 547, Level 16, State 0, Line 1 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint ActualsDay_fct_ent_CustomerHierarchyLvl03_FK_PayTo The

  • Handling Errors in SQL Server 2012

    Updated: 2013-01-03 00:00:00
    The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included in SQL Server 2012 that, combined with the TRY ... CATCH block, makes error handling far easier. Robert Sheldon explains all.

  • SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video

    Updated: 2013-01-02 01:30:34
    Every developer has a different habit. Some like to format the functions in upper case and some wants it in lower case. I often see developers listing the columns in SELECT clause in a different way. I have my own preference but I do respect the other developer’s preference as well. I do not advise [...]

  • SQL Server 2012 Sequences

    Updated: 2013-01-01 22:07:00
    SQL Server 2012 sequences provide Oracle style flexibility in doing parent child inserts in situations where the IDENTITY property would otherwise be used. When the IDENTITY property is used to populate a primary key in a parent table, some type of after the fact operation is necessary to find out what the just inserted primary key is. THis value is then used as a foreign key value in the inserts into the child tables. Many people prefer knowing the primary key in advance before the insert into the...(read more)

  • Geek City: What Triggered This Post?

    Updated: 2013-01-01 00:00:00
    I’d really like to get another post up onto my much neglected blog before the end of 2012. This will also start one of my New Year’s resolutions, which is to write at least one blog post a month. I’m going to tell you about a change in SQL Server that wasn’t announced in any “What’s New” list that I ever saw, perhaps because it was just a chance in internal behavior, and nothing that required any change in user applications. Do you retest what you know is true for every new version? When I update...(read more)

  • The Year That Was - 2012

    Updated: 2012-12-31 19:31:00
    2012 was, simply stated, a year that kicked my butt. When I wasn't struggling professionally, I was struggling personally. Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles. I apologize to those of you who are normally on my Christmas card list for not sending any this year. The wind was not in my sails. On the positive side of the ledger, I made a scary but exciting leap to SQL Sentry midyear. This was...(read more)

  • SQLAuthority News – Last Post of Year 2012

    Updated: 2012-12-31 01:30:03
    The year 2012 was the most interesting year. If I start listing what was special about this year – I think it will take me 2-3 days to just write a blog post about this subject. Let me pick few things which I would like to specifically call out. SQL in Sixty Seconds Series We [...]

  • The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems, and AWE

    Updated: 2012-12-30 23:36:00
    , THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Argenis Fernandez Entire Site Search Home Blogs Downloads Opml Argenis Fernandez The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems , and AWE I’m taking a break from my DBA Best Practices blog series to talk about this today the series continues after the Holidays I love to be proved wrong . Really , I . do Recently we had a discussion in an distribution list where somebody asked whether a SQL Server 32-bit instance could address more than 4Gb of RAM when running on top of a 64-bit OS . One of the really smart guys in Microsoft SQL Server Support replied sure , just add more RAM and enable AWE SQL will use that memory” . I was much convinced that this was

  • The SQL Query Optimizer – when Logical Order can get it wrong

    Updated: 2012-12-30 05:32:25
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Rob Farley Entire Site Search Home Blogs Downloads Opml Rob Farley Rob Farley Owner Principal with LobsterPot Solutions a MS Gold Partner consulting firm Microsoft MVP SQL Server and leader of the SQL User Group in Adelaide , Australia . Rob is also a Director of PASS , and runs training courses around the world in SQL Server and BI . topics The SQL Query Optimizer when Logical Order can get it wrong It’s very easy to get in the habit of imagining the way that a query should work based on the Logical Order of query processing the idea that the FROM clause gets evaluated first , followed by the WHERE clause , GROUP BY , and so on finally ending with whatever is in the SELECT clause . We

  • SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)

    Updated: 2012-12-30 01:30:49
    Here is the question received from user – the email was long and had multiple request from reader to resolve this error. Scenario: The user was trying to import data from Excel to tables in SQL Server Database. Every time he attempted to import the data he faced following error. He tried using SSIS package [...]

  • SQL SERVER – Weekly Series – Memory Lane – #009

    Updated: 2012-12-29 01:30:13
    Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]

  • SQLAuthority News – NuoDB RC2 Available to Download – General Availability in Near Future

    Updated: 2012-12-28 01:30:55
    Regular readers who are familiar with my blog will be also familiar with my interest in NuoDB. It is a very innovative new age database which follows 100% SQL, ACID and Elastically Scalability. Here is an earlier article on this subject where we explain why sharing will no more required due to the implementation of [...]

  • End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI

    Updated: 2012-12-27 18:26:38
    , THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SQLBI Marco Russo Entire Site Search Home Blogs Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server End of 2012 and news in 2013 for PowerPivot , ssas tabular and BI This year is going to end , Maya failed their predictions and while this is bad for predictive industry , it’s also good for all of us We’ve seen many news in Microsoft BI : stack Excel 2013 has been RTM’d its General Availability is expected in early 2013 but many early adopters are already using it daily myself included PowerPivot and Power View are both integrated in Excel 2013 and I think that they are the most compelling reason to upgrade your Excel

  • Nice set of updates to Azure over the last few days - Data Sync now in the HTML Portal - Updates to the CLI

    Updated: 2012-12-27 07:56:00
    THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in The Bit Bucket Greg Low IDisposable Entire Site Search Home Blogs Downloads Opml The Bit Bucket Greg Low IDisposable Ramblings of Greg Low SQL Server MVP , MCM and Microsoft RD SQL Down Under Nice set of updates to Azure over the last few days Data Sync now in the HTML Portal Updates to the CLI Scott Guthrie posted about the Azure-related changes that have happened over the last few . days Of particular interest to me was that Data Sync was now in the new HTML portal , and that the Azure store now works in a bunch more . countries Generally I like the newer HTML portal but I'm still finding that it applies different validation rules to SQL passwords than Windows Azure SQL Database

  • SQL SERVER – Creating Database with Different Collation on Server

    Updated: 2012-12-27 01:30:24
    I recently came across an organization who had very interesting infrastructure setup. Their business domains is analytics. They process millions of the records and how many clients who have case sensitive tags on their server which they want to measure. However, there are many places they do not want to care about case sensitivity. They [...]

  • Love your enemies.. it pisses them off.

    Updated: 2012-12-26 19:27:00
    . . THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Maria Zakourdaev Entire Site Search Home Blogs Downloads Opml Maria Zakourdaev Love your enemies . it pisses them off . There is always a threat from somewhere . Old-style DBAs are standing on the shaky . ground 5 years ago I remember myself defending the SQL Server against the domineering Oracle DBAs . The arguing was always about who is better” . The Management Studio was a great weapon against sqlplus . And you could always use a the DDLs are not a part of the transaction thing . nbsp Without any Oracle DBAs around I must admit that Oracle is pretty amazing product although it requires a huge deal of . tuning Then came an era of NoSQL . It’s not easy to compete against such fast

  • SQL SERVER – Take Database Backup using SSMS – SQL in Sixty Seconds #037 – Video

    Updated: 2012-12-26 01:30:52
    Whenever I am suggesting something which changes how database works or the existing status of the database, my suggestion along with it is to take the database backup before making such changes. If the changes are in configurations, that can be easily revert but if the changes are such that it will impact the data, [...]

  • SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions

    Updated: 2012-12-25 01:30:40
    Some questions never get old. Let me list a few of them. As the year 2012 is about to end, today I will talk about three of the most asked questions to me in an email. Q 1: What is AdventureWorks and where can I get it? A 1: AdventureWorks is sample database build by [...]

  • SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.

    Updated: 2012-12-24 01:30:30
    Here is the interesting conversation I recently heard between two teammates in one of the organizations I visited. DBA Jr: I can’t take transactional backup of the database. DBA Sr: What is the recovery model? DBA Jr: How to find the recovery model? DBA Sr: Go to SSMS >> Right Click on Your Database >> [...]

  • SQL SERVER – What is Hekaton? – Simple Words Explanation

    Updated: 2012-12-23 01:30:00
    Readers of this blog will know that I recently attended SQL Server (PASS) Summit 2012.  There were, of course, a lot of fascinating subjects and people, but let me talk about one of my favorites right now.  Ted Kummert, corporate vice president of the Data Platform group at Microsoft, announced that the new version of [...]

  • SQL SERVER – Weekly Series – Memory Lane – #008

    Updated: 2012-12-22 01:30:27
    Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]

  • SQLAuthority News – Chrome Browser – Personal Technology

    Updated: 2012-12-21 01:30:50
    Almost every computer you can buy these days will come with Microsoft Windows installed on it automatically.  Also installed automatically – Internet Explorer, Microsoft’s web browser.  Many of us use this browser without a second thought, but in this latest Personal Technology Tip and Trick I thought I’d expand your horizons and talk about my [...]

  • SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server

    Updated: 2012-12-20 01:30:02
    A common question – I often get from Oracle/MySQL Professionals: “What is the Equivalent to CURRENT_TIMESTAMP in SQL Server?” Here is a common question I often get from SQL Server Professionals: “What are differences between Difference Between CURRENT_TIMESTAMP and GETDATE ()?” Very simple question but have showed up so frequently that I feel like to write about [...]

  • SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video

    Updated: 2012-12-19 01:30:09
    Developers often face situations when they find their column have duplicate records and they want to delete it. A good developer will never delete any data without observing it and making sure that what is being deleted is the absolutely fine to delete. Before deleting duplicate data, one should select it and see if the [...]

  • Hypothetical Indexes on SQL Server

    Updated: 2012-12-18 00:00:00
    Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.

Previous Months Items

Dec 2012 | Nov 2012 | Oct 2012 | Sep 2012 | Aug 2012 | Jul 2012