Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
Transactional Replication Setup (by Abi Chapagai)
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
Why are we still talking about Women in Tech?
Today we have a guest editorial from Jen McCown, one half of the Midnight DBAs. Jen wonders why we are still talking about women in technology? Women do the same jobs as men in this field.
Writing Nearly Codeless Apps: Part 1
A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.
Scripts to use XML to insert and update rows in a SQL Server table
The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.
Strange but True - Report Parameter Label Blank
Here is another one of those strange but true things that I come across every so often which I thought...
Idera SQL Diagnostic Manager 6.2 Review
A look at Idera's Diagnostic Manager and how it can help you diagnose performance issues on your server instance.
No, I do not provide childcare at my technology events...
A guest editorial from Julie Yack looks at the difference between men and women from the perspective of one very successful woman in technology.
Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1
The first in this three part series on using Microsoft Assessment and Planning (MAP) Toolkit 5.0 introduces the toolkit and gets started with install and using it.
October Question: Tell us about your favorite experience as a participant in the SQL Server community.
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers