Browse by Tags

How to write or deploy Secure Transact-SQL - gotchas & tips?

Published 18 September 8 2:16 AM | SqlServer-QA.net

I have been thiking to write this topic in this blog since last 3 months, before that I have done fair amount of work to get you sensible & helpful resource in securing your SQL Server environment. This was the question asked by one of the user when...

Filed under: sql server, documentation, best practices, tsql, injection, reference, guidelines, dynamicsql

Installation gotchas and guidelines - SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1

Published 1 September 8 3:2 AM | SSQA.net

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage. No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present...

Filed under: sql server, blogs, sql express, installation, developers, new features, isv, guidelines, gotches

Working with DateTime data types in SQL Server, guidelines and explanations!

Published 26 August 8 2:41 AM | SSQA.net

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it...

Filed under: datetime, sql server, usage, global, datatype, guidelines

SQL Server Express - get sample kits in express way

Published 30 June 8 3:30 AM | SSQA.net

For every new user in SQL Server world and experienced users to get used to newer version of SQL Server, having sample kit will definetly help out. In this scenario I often get emails asking about any samples or documentation (procedures) to get more...

Filed under: sql server, download, sql express, sample, guidelines, kit