It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
2009-10-07
469 reads
Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition, focusing in particular on security-related topics. This article continues this subject by describing other technologies that assist with data protection, their corresponding configuration settings, and a few authentication and authorization caveat
2009-10-07
2,632 reads
MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.
2009-10-06
4,737 reads
Take this survey from the SQL Server developer team at Microsoft.
2009-10-06
901 reads
Because installing SQL Server is so easy it is tempting to cut corners, fail to plan properly and blindly accept default options without considering the alternatives.
2009-10-06
4,162 reads
Create a linked server on the fly in this tip.
2009-10-06
3,401 reads
This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.
2009-10-05
60,807 reads
With SQL Server 2005 DMVs, we can easily find query performance statistics. Every DBA has a favorite script to find query performance stats. I also have one. But, are all the queries captured by the DMVs? In this tip I will walk through capturing some of this data and show what is capture and what is not captured by the DMVs.
2009-10-05
4,784 reads
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-10-05
4,542 reads
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
2009-10-05
512 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers