More Results
-
SQL Server meets database application security
These days, developers and database administrators have to pay more attention to database and application security than ever before. Not long ago, even... Tip | SearchSQLServer.com
-
Legacy file systems, away: Dealing with an unsupported file system
What do you do when you've found the perfect solution to your problem, but it's no longer supported?
This was the issue that faced the City of Aurora, Colo. Longtime users of the PolyServe file... Feature | SearchSQLServer.com
-
Denny Cherry's 2013 predictions (and wishes) for SQL Server trends
2012 was an amazing year for Microsoft SQL Server. The most major event was the release of SQL Server 2012, which came out in the middle of the year. I've got a feeling 2013 is going to be just as exciting, if not even more so. Here are my... Feature | SearchSQLServer.com
-
Basic SQL Server security best practices
Editor's note: This article is the fourth and final in an ongoing series on SQL Server security. Be sure to check out parts... Feature | SearchSQLServer.com
-
Excerpt: The many levels of SQL Server 2012 business intelligence
In Chapter 1, we discussed the fact that business intelligence (BI) should be utilized at all levels of an organization to promote effective decision making. While it is true that business intelligence is useful throughout the organization, the... Excerpt | SearchSQLServer.com
-
SQL Server 2012 security: Changes for the newest version
Editor's note: This is part two of a four-part series about SQL Server security. The first part, "Why SQL Server security... Series | SearchSQLServer.com
-
Coding for seamless SQL Server database mirroring
SQL Server database mirroring has been providing a high-availability option since 2005. One feature is automatic application failover to the secondary server when the primary server is no longer available. This article discusses automatic... Tip | SearchSQLServer.com
-
T-SQL analytic functions in SQL Server can help solve problems quickly
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical... Tip | SearchSQLServer.com
-
SQL Server management trick: Connecting when admins are locked out
Securing SQL Server is one of the primary responsibilities of a database administrator. However, there are scenarios when a DBA will have to manage SQL Servers for which he doesn’t have a valid system administrator login. This can happen when an... Tip | SearchSQLServer.com
-
Great new SSIS features for BI developers
Editor's Note: This is the first of a three-part series by frequent SearchSQLServer.com contributor Robert Sheldon about new SSIS features that will make the jobs of BI developers easier -- and why.
Developers are always... Tip | SearchSQLServer.com
Search Again: