SQL Server Security Tips and Tricks Several readers wrote in with their ideas and approaches to security, working with what amounts to mixed security environments and the like. I thought I’d pass along some of them here – feel free to send in your thoughts and approaches as well. Roger: "We run multiple web applications against SQL Server sometimes with […]

Featured Article(s) Create an ADO function by stored procedure name In this article I would like to present and describe the SQL script which produces front-end ADO called a function by a stored procedure name. For both VB.NET and C#. Handling Security With SQL Server How do you approach security for SQL Server? It’s a tad easier question if you […]

Featured Article(s) Working with Windows Services in Microsoft .NET Windows Services are programs that are executed in the background, have no user interface and are long running executable applications. They can be configured to start automatically or even they can be started manually. These applications are actually controlled by the Service Control Manager. This article will teach you how to […]

Spec’ing Out A Project We’ve been talking a bit about the process of taking on work – be it internal or external. Part of the key is setting expectations and defining what you need. From Ralph: "K.J. said ‘5:The IT vendor foots the bill for work effort required for creating the fixed bid, and verifying that the specifications are satisfactory […]

Keynote Today: SQL [Server] Injection Today’s keynote features code you can use, web pages to swallow "500" errors and full tips on working to beat injection. [Hope to see you there] Project Estimation Tales, Part… well, Part .Next. Chuck: "This all sounds way too familiar and troubling, especially those requests for estimates that are from Product Mgmt. Here we have […]

Day 1 – SQL Server Virtual Conference – Opens Today! The doors are opening today on day 1 of the virtual conference (register here) – today we have an opening mini-session on SQL Injection (part 1 of 2!) and sessions on SQL Server Profiler, SQL Server T-SQL Enhancements, Introduction to SSIS, SQL Server 2008 Filtered Indexes and Statistics and even […]

Featured Article(s) Recovery Of TempDB (Recreate TempDB) How to recreate your tempDB if the drive containing tempdb fails and becomes inaccessible The SQL Server Virtual Conference, Day 1, is Tomorrow. This is NOT a series of webinars. Great quality, great tools. Want to see? In 30 seconds, you’ll know. Check out this great video where you can see much more […]

Curious About What the SQL Server Virtual Conference is all About? In 30 seconds, you’ll know. Check out this great video where you can see much more about speakers, the experience and a lot more. 30 seconds. [Take a look here, no strings] (30 second video demonstration) By the way, the conference is Tuesday. We’re in the middle of a […]

Creating PowerPoint Slides that Reference SQL Server? You’ve got to see this cool tool. From right inside PowerPoint, you can directly connect to MSAS and pull information, create outstanding slides, use templates, update slides with new information and a whole lot more. If you’re finding yourself creating presentations in PowerPoint so you can discuss information in your systems, you could […]

Featured Article(s) SQL Server 2005 XML Optimization Tips Here are some helpful tips to ensure you work with SQL Server 2005 XML in the most efficient manner possible. Have You Seen This Toolset? I don’t know if you’ve heard, but Idera has a great set of tools – 24 of them, actually – available as a complete set… for $195.00. […]