Start a command prompt using the "Run as administrator" option. If you do not use this option you may be a message that 'Access is denied.' To start the default instance of SQL Server type the following in command … [Continue reading]
How to start and stop Microsoft SQL Server from the command line
October 29, 2013 by Leave a Comment
Equivalent of DUAL table in Microsoft SQL Server
October 29, 2013 by Leave a Comment
I spent quite a few few years developing PL/SQL on Oracle databases and had grown accustomed to its syntax. One of the things which I didn't enjoy was that the 'FROM' clause in a SELECT statement was required (it is not in TSQL). This causes a bit … [Continue reading]
Microsoft SQL Server user problem after restore (orphaned users)
October 21, 2013 by Leave a Comment
The Problem: After creating user accounts and restoring an Microsoft SQL Server database onto another, it was discovered that database logins didn’t work. This problem is due to the mapping of database users to SQL Server logins to a database. There … [Continue reading]
T-SQL – Search Stored Procedure Code for Text
February 6, 2013 by 3 Comments
Often I have to search for stored procedures in SQL Server to find pieces of text. The motivation for this is to find procedures which use a table or to look for code which the developer has done silly things like hardcoded directories (Boris....). … [Continue reading]
C# Methods with Unlimited Parameters
January 11, 2013 by 2 Comments
To create a method that can take unlimited parameters, utilize the params keyword in the method declaration. This allows you to specify a method parameter that take an argument where the number of arguments is variable. You are not allowed to have … [Continue reading]
How to determine the version and edition of SQL Server
January 9, 2013 by Leave a Comment
Connect to the instance of SQL Server, and then run the following query (this will work for all versions of SQL Server): [crayon-632281b5ce2e3485795148/] The result form the query will look like the following. Microsoft SQL Server 2008 (SP1) - … [Continue reading]
How to get the column names of a table in SQL Server (T-SQL)
January 8, 2013 by 4 Comments
The following query can be run (substitute the ‘TableName’ in the query with the table name you want column information on) to get the column names for any table in T-SQL. [crayon-632281b5ce42f168572469/] [crayon-632281b5ce434021951720/] To get … [Continue reading]
How to take a screenshot on a iPad.
August 3, 2012 by Leave a Comment
The iPad is a very easy to use device. What is surprising is that sometimes things that you wouldn’t normally do everyday are possible but are hidden away. Thankfully taking a screenshot on the iPad is very easy to do. All that is required is to … [Continue reading]
Enable xp_cmdshell using sp_configure
August 1, 2012 by Leave a Comment
When you install a SQL Server instance, any feature that is not necessary for the core engine to run has been disabled by default. xp_cmdshell is a significant security risk because it allows a compromised SQL Server to elevate the attack to the … [Continue reading]
