- Subscribe to this page:
- RSS
- Email Alert
policies and procedures
(4368 results)-
Blog Post
Passing table valued parameters in SQL Server 2008
August 27, 2007 12:47pm PDT
SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer...
5 Latest comment by joshgeake
-
Blog Post
Five free apps to help remind you to take a break
December 3, 2012 1:40pm PST
Jack Wallen has found apps that remind users to take breaks and practice good ergonomics, and they do this without costing a penny.
7 Latest comment by HAL 9000
-
Blog Post
Five tips for handling errors in VBA
October 9, 2010 8:15am PDT
Effective error handling can mean the difference between a seamless, user-friendly experience and a problem-plagued application. These best practices will help ensure your apps run as intended,...
3 Latest comment by gsmisek
-
Blog Post
The future of IT security compliance: 201 CMR 17.00
April 30, 2013 6:00am PDT
Why should you be concerned about a security rule that is part of the State law of Massachusetts -- especially if you aren't in business there? Donovan Colbert explains how compliance regulations...
5 Latest comment by dcolbert@...
-
Blog Post
Generate dynamic SQL statements in SQL Server
March 10, 2008 1:59pm PDT
When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. Tim Chapman explores how you can use this...
7 Latest comment by Tony Hopkinson
-
-
Blog Post
The CIO resume vs. The CTO resume
February 13, 2013 6:35am PST
Don't confuse the position of CIO with CTO when you're applying for one of those jobs. Resume expert Jennifer Hay talks about the difference.
9 Latest comment by Alexandrea_AnywherePad
-
Blog Post
How to automatically execute a Word macro when you create, open, or close a document
March 17, 2011 7:57am PDT
By adding a macro to a template's New, Open, and Close event procedures, you can automate a number of tasks, making you more efficient and productive.
13 Latest comment by Andy P Roberts
-
Blog Post
10 things to do with old computing equipment
February 5, 2013 8:11am PST
When equipment reaches the end of its useful life, IT must either dispose of it or find it a new home. Here are several good ways to handle the situation.
64 Latest comment by Worth2Cents
-
Blog Post
Six lines your boss should never cross
April 17, 2012 10:18am PDT
A list of six ways you can tell if your boss has crossed the line of professional behavior.
90 Latest comment by dl_wraith
-
Blog Post
37 keyboard shortcuts for moving faster in the Visual Basic Editor
August 5, 2009 12:00am PDT
If you spend a lot of time in the Office VBE, these keyboard shortcuts can make your work go more quickly.
5 Latest comment by mw00110011
-
Articles
Determine when to use stored procedures vs. SQL in the code
July 1, 2005 7:00am PDT
Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.
1
-
Articles
Using recursion in stored procedures
May 9, 2005 2:55pm PDT
The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL.
5 Latest comment by mahee.jabeen@...
-
Blog Post
10 boring (but really important) things you should know about HIPAA compliance
June 14, 2012 6:28am PDT
Staggering fines are being levied against companies that fail to comply with HIPAA regulations. Here are 10 critical policies to have in place (even if you don't fall under HIPAA).
15 Latest comment by GreatZen
-
Blog Post
Write your own sp_lock system stored procedure in SQL Server 2005
January 7, 2008 11:57pm PST
Tim Chapman discusses how you can use the new dynamic management views in SQL Server 2005 to write your own custom system stored procedure to replace sp_lock.
4 Latest comment by mgalivi@...
-
Blog Post
Take advantage of undocumented SQL Server iteration procedures
July 3, 2008 8:47am PDT
Here's a look at how you can use two built-in system stored procedures -- sp_msforeachdb and sp_msforeachtable -- to iterate through SQL Server tables and databases.
5 Latest comment by mahrumer
-
Blog Post
Your medical records, HIPAA, and the illusion of privacy
January 7, 2013 7:44am PST
HIPAA is supposed to protect our private medical records from prying eyes, but there are many exceptions and gaps as Michael P. Kassner found out while doing some research.
42 Latest comment by Gdl_kinG
-
Articles
Increase SQL Server stored procedure performance with these tips
March 5, 2002 8:00am PST
Database developers often use stored procedures to increase performance. Here are three tips to help you get the most from your SQL Server stored procedures. We've even thrown in a bonus...
8 Latest comment by ntcse@...
-
Blog Post
10+ things you can do to avoid ethical breaches
October 12, 2011 11:16am PDT
If you're headed toward an ethical quagmire, a few basic steps can help you find your way back to the high ground.
16 Latest comment by sboverie
-
Blog Post
Five common database development mistakes
August 30, 2012 10:36am PDT
Here are some of the most common gaffes Justin James sees in database development, along with advice on what to do to not make them.
41 Latest comment by Jaqui
-
Blog Post
Find blocking processes using recursion in SQL Server 2005
January 28, 2008 8:57pm PST
SQL Server 2005 has several system tables and views that can provide a ton of insight into blocking problems that you may be facing in your database environment. Through these procedures, you can...
6 Latest comment by jbienn@...
