(Gregory Larsen) In my last article I talked about how you could restrict the number of rows returned by using the TOP clause. In that article all my examples where about using the TOP clause to only select data, not update data.

(Pinal Dave) I just can’t get enough of the error messages that land into my Inbox almost every single day. I do my due diligence of making a search in my blogs and I try to hang around in the forums from time to time to learn what people are getting as errors.

(Chandrika Bandi) Views in SQL Server provides you to work with virtual tables, to hide complex queries or sensitive data.

(Ghanesh Prasad) You have a requirement where users want to filter report data in SQL Server Reporting Services by entering a list of comma delimited values instead of choosing from a dropdown list. In this tip we show how this can be completed with Reporting Services.

(Tim Radney) Virtualization is very popular for organizations: it allows them to better utilize hardware by combining multiple servers onto a single host, provides HA capabilities, and gives a reduction in various costs like heating/cooling, SQL Server licenses, and hardware.

(Dwain Camps) After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that devel

(Robert Sheldon) Microsoft’s recent acquisition of Revolution Analytics represents a significant move on the company’s part. Revolution Analytics is built around the highly popular R language, an open source programming language designed specifically for statistical analytics.

(Kenneth Fisher) I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing 4 old ones, renaming 4 and then altering the datatype for those 4.

(Pinal Dave) As March comes, most of us are trying to chase our dreams and hope the much awaited yearend review comes good for us. I know many pray and don’t realize it is just an assessment of what was done the whole of last year.

(Chris Bell) To quickly check SSL is configured on your SQL Server you can run the following query.