Browse by Tags

Windows Server 2008 deploy within your environment securely!

Published 6 March 8 2:50 AM | SSQA.net

Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day...

Filed under: sql server, databases, microsoft, security, server, windows, 2008, environment

Scottish Developers - Gary Short's Favourite Design Patterns

Published 21 December 7 3:59 PM | SSQA.net

If you've heard of design and enterprise patterns and want to find out a bit more... What: Lecture Host: Scottish Developers When: Wednesday, January 16 at 7:00pm Where: CPDC, Glasgow Caledonian University RSVP & More information: http://www.scottishdevelopers...

Filed under: sql server, databases, microsoft, event, events, developers, scotland, scottish developers, glasgow, design

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?

Published 19 December 7 6:6 AM | SSQA.net

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes'...

Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring

Changing ports on production SQL Server - things to watch for 1433

Published 7 December 7 12:29 PM | SSQA.net

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give...

Filed under: sql server, databases, microsoft, security, best practice, port, 1433, operating system

Windows Vista SP1 Release Candidate Announcement

Published 6 December 7 12:32 PM | SSQA.net

Windows Vista SP1 RC is released on 05th December to the Beta Testers on the Microsoft-Connect and on 06th December it is available via MSDN and TechNet subscribers. Few things if you want to know about Vista SP1 RC refer to the following notes from Microsoft...

Filed under: sql server, databases, microsoft, best practices, vista, testing, beginners, service pack1, rc

How to find which version of Analysis Services you are running?

Published 5 November 7 11:54 PM | SSQA.net

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out!...

Filed under: sql server, databases, microsoft, integration, ssis, ssas, version, Analysis Services

SQL Server 2005 using Cryptography & Encryption what they are for?

Published 13 September 7 7:46 AM | SSQA.net

Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication...

Filed under: sql server, performance, databases, microsoft, security, audit, encryption, authentication, authorization, cryptography

Microsoft SQL Server Compact 3.5 for Windows Desktop Beta 2, Windows Mobile Beta 2 and Server Tools Beta 2

Published 7 September 7 6:26 AM | SSQA.net

SQL Server Compact edition is best used for replication purpose within the enterprise wide with a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains...

Filed under: sql server, databases, microsoft, server, download, windows, replication, compact, desktop, mobile

Shall I drop pubs and northwinds databases, how about Adventureworks?

Published 21 June 7 3:36 AM | SSQA.net

As you may be aware SQL Server installation (70 & 2000) will automatically install the sample databases pubs and northwind, if you aren't using them or not a training institute then simply drop them. Whereas this behaviour is changed in SQL Server...

Filed under: sql server, databases, microsoft, instance, documentation, sample, install