Accounting for Windows Azure
On Thursday March 21st 12PM noon Central, Steve Hughes will discuss Accounting for Windows Azure when looking at Data Architecture.
Full Text Searches on Documents in FileTables
SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. The best way of learning FileTable is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.
Algorithm Secrecy is not Security
This week Steve Jones talks encryption and why you shouldn't be implementing anything you've invented.
The Backup Process
Today Steve Jones talks about backups. Setting up a process is good, but you cannot count on it working forever. You need to check periodically to be sure it's working, and that your skills are not deteriorating.
Database Deployment Challenges
There are a number of challenges that make the deployment task more difficult. Alex reviews the common techniques for deploying new databases and upgrading existing ones, and their flaws, and argues the advantages of an automated, incremental, script-based approach to deployments.
SQLServerCentral at SQL Intersection
Steve Jones and Grant Fritchey will be speaking at the SQL Intersection conference in April. Come join them in learning about SQL Server in the spring.
Exchange 2010 - A Practical Approach
Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use guide to this latest platform, full of useful examples and top tips for SysAdmins, both new and experienced.
Inconsistency
This Friday Steve Jones notes that changing and altering your opinions is good and invites you to share things you might have learned that changed your mind in the past.
Mastering SQL Server Profiler
SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.
SQL Server Execution Plans
Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.
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