Browse by Tags

Data Dude gets you a great news about Visual Studio Team Edition for Database Professionals!

Published 22 August 8 3:55 AM | SSQA.net

Data Dude - if you know about these 2 words then you know what I'm talking about. Visual Studio Team Edition for Database Professionals is an excellent tools for the users to build SQL databases in a managed project environment with support for versioning...

Filed under: sql server, services, community, code, visual studio, data dude, team edition, vsts

Don't fall for SPAM - phishing email about CNN.com email alerts

Published 9 August 8 12:43 PM | SSQA.net

Do not click any of the links below: Here is the piece of advice I would like to share that do not fall for tricks played by SPAMMERS and phishing email you see below: ************************************************************************* Alert Name...

Filed under: microsoft, security, services, enterprise, alert, code, spam, email

Licensing - what is Microsoft's stand on public licensing when it comes to Open Source software?

Published 31 July 8 4:8 AM | SSQA.net

It is a compulsory requirement that you need a license to work/operate a software application. That means it is required for each physical or virtual processor accessed by an operating system environment running such a software. I must admit Licensing...

Filed under: microsoft, community, code, licensing, strategy, policy, open source

CLR Stored Procedures - handling security on SQL Server side

Published 24 July 8 3:52 AM | SSQA.net

Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework...

Filed under: sql server, security, clr, .NET, code, practices, peverify

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!

Published 15 February 8 4:26 AM | SSQA.net

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...

Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in

Development environment for SQL Server databases, gotchas!

Published 9 November 7 4:35 PM | SSQA.net

Do you have any criteria for your Development Environment within the SQL Server platform? Do you perform end-to-end testing whenever a new hotfix or service pack needs to be applied on the SQL Server? So think about having seperate Database Development...

Filed under: sql server, microsoft, red-gate, best practices, environment, code, visual studio, developement, developers

Capitals or small letters - which one you choose when you are writing TSQL code?

Published 13 July 7 9:25 AM | SSQA.net

Have you ever gave a thought about writing a code within your development environment, I'm talking about writing TSQL scripts and not going for programming languages such as C# or ASP.net. So what is your favourite in this case: Look at this SQLBlog...

Filed under: sql server, microsoft, table, tsql, code