Archives for Language features, Development Methodologies - Page 16
Data Security in SQL Server (and other databases)
If you have sensitive data ( HIPAA data), you need to consider both encryption as well as SALTING of your data at the database level. Encryption Prior to 2008, SQL…
Top 20 worst performing SQL Server queries
Top 20 worst performing queries --------------------------------- and thus you would see "similar" query text in the proc cache each with its separate compiled plans */ DECLARE @SQLString nvarchar(500) DECLARE @cnt…
Adding a user to subversion, granting access to a subfolder
Let us say you added a new user (called newuser) - and want to grant her access to your subfolder myproject/sourceYou would modify the Authz file - by adding the…
Maintenance Plan for SQL Server 2014
These scripts are owned and developed by Ola Hallengren DatabaseBackup: SQL Server Backup DatabaseIntegrityCheck: SQL Server Integrity Check IndexOptimize: SQL Server Index and Statistics Maintenance Download Maintainance Script for…
TFS 2013 –show me all the conflicts only
To only view the conflicts (conflicting files) for pending checkins in TFS 2013, try the following: View TFS Conflicts Only Go to Team Explorer Select Pending changes In the Pending…
SQL Server Database CPU Utilization and Memory Usage
Apart from Query Performance analysis and Schema Objects analysis (indices, statistics etc.), there are two important metrics that are usually sought out for a poorly performing SQL Server instance. These…
Upload entire solution into TFS–first time
Right click solution - Add Solution to Source Control Now, all the files will show up in TFS with a + sign - they have been 'added' but not 'checked…
The quickest way to compare two lists (for matching entries–i.e. duplicates)
In Excel (2007 and above), place each list of values in its own column. Now, Select cells in first list, then hold CTRL key and then select the second Go…
Filesystem notes from the real world–C#
These are just some quick tidbits about file processing in C#. Reading in files, reading in LARGE files, Reading and Processing Large Files. Reading a file (use a StreamReader) if…
Overall Strategy for Monitoring SQL Server Performance
This is just a quick cliff’s notes on what to look for in terms of the Physical Design of the database. The four main categories of concern are : Memory…