Email Alerts
-
Tips for deploying SQL Azure Federations
Reduced SQL Azure pricing, an upgraded management portal, increased database size and the SQL Azure Federations Data Migration Wizard mean multi-tenant and “big data” projects are big possibilities.Tip
-
Is cloud-based business intelligence a safe bet?
Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don’t forget to ask some crucial questions.Tip
-
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing
With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.News | Wed Mar 14 12:40:37 EDT 2012
-
Don’t sweat migration from Oracle, Sybase to SQL Azure
Are you considering moving your database to Azure? Concerned about complexity? Read this tip from expert Denny Cherry. Migrating to SQL Azure might be the easiest move ever.News | Mon Mar 12 17:15:52 EDT 2012
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing.Tip
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
Five things in SQL Server not in SQL Azure
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server.Tip
-
Three tips for a better SQL Azure migration
A successful SQL Azure migration means picking the right migration tool and loading data into SQL Azure properly.Tip
-
SQL Server 2012 release approaches -- what you need to know
Microsoft will soon come out with the long-awaited SQL Server 2012 release, but will your system be ready to take full advantage of the new version, also known as Microsoft Denali? Find out.Feature
-
Plan ahead for a smooth SQL Server migration
The thought of a SQL Server migration makes many organizations nervous, but they don’t have to be, writes consultant Don Jones. Get tips on making the switch simple.Tip
- VIEW MORE ON : Migration and Planning
-
Speed up execution times in Microsoft SQL Azure
Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure.Tip
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together?News | Thu Mar 01 13:33:49 EST 2012
-
Meet compliance requirements with improved database security practices
Small but consistent changes are the trick to securing your SQL Server database and maintaining compliance with the latest industry rules and regulations.Tip
-
The fine line between not encrypting your databases and breach notification
Neglecting to encrypt personal information in your SQL Server database can leave your organization vulnerable to certain compliance issues. Get the facts to keep you and your company protected.Tip
-
Sarbanes-Oxley compliance checklist: IT security and SQL audits
If your SQL Server environment is not yet expected to meet Sarbanes-Oxley (SOX) Act compliance standards, it soon will be. In this tip, SQL Server expert Michelle Gutzait presents security practices, procedures and documentation that prepare you for complying with SOX -- along with checklists that SQL Server administrators and developers can use as a guide for inspecting their systems.Tip
-
Security testing for compliance -- just how much do you need?
Because of government demands, testing your databases and related SQL Server applications for security flaws is no longer simply on the IT wish list. But how much testing is really necessary? IT security specialist Kevin Beaver notes key systems to test, the "must-have" tools for protecting sensitive information and the best approach for database security testing.Tip
-
Logging for security compliance in SQL Server
Logging for security compliance in SQL Server can be tricky. Recommendations come from all directions: vendors, auditors and lawyers. As a SQL Server administrator, it's your job to determine what's reasonable based on risk. Contributor Kevin Beaver outlines log options, and other considerations when delving into audit logging and system monitoring.Tip
-
Find the size of every database
This handy script will find the size of every database in SQL Server 2000 without using the sp_spaceused function.Tip
-
Alternate way to find database size
Here's a quick SQL Server script that finds the size of the database and separates the log and data file sizes.Tip
-
Are you ready for a compliance audit?
SOX, HIPAA, SB1386, EUDPA, GLBA. Are you ready?Tip
- VIEW MORE ON : Compliance
-
SQL Server virtualization: Not always a good idea
SQL Server virtualization may seem like a magic bullet, but there a few scenarios that might cause businesses to reconsider.Tip
-
In data warehousing, cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider.Tip
-
Microsoft SQL Server 2012 pricing, licensing packed with changes
SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing.Tip
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
SQL Server consolidation good -- not checking metrics bad
SQL Server consolidation could save your company big money, writes expert Denny Cherry, but first you’ll need to examine metrics like concurrent connections, buffer pool size and drive space.Tip
-
SQL Server security in virtual, physical worlds virtually the same
SQL Server security issues in virtualized environments pretty much mirror the challenges in physical environments, experts say. Standard security guidelines apply.Feature
-
SQL Server virtualization risks: among all the pros, some cons
Virtualization promises big savings for businesses, and few are decrying its influence. But is it always the answer? Are there SQL Server virtualization risks to learn about first?News | Tue Jul 05 00:00:00 EDT 2011
-
SQL Server virtualization is inevitable: Get the right hardware
Buying hardware for SQL Server virtualization hosts entails some specialized shopping skills. Get some expert tips on what to look for.Feature
-
SQL Server virtualization more than a passing trend?
Virtualization may be taking data centers by storm, but what’s behind the trend? In this month’s “SQL in Five,” SearchSQLServer.com asks Microsoft’s Mark Kromer about the benefits and difficulties of virtualizing SQL Server.SQL in Five
-
Virtualizing SQL Server: Myth or reality?
With benefits such as cost savings and high-availability options, SQL Server virtualization is taking the IT world by storm. Here are a few things to keep in mind.Tip
- VIEW MORE ON : Consolidation and Virtualization
-
SQL Kilt Day at PASS Summit 2011
A tradition emerging from the PASS Summit has men slipping into kilts to show solidarity with the Women in Technology interest group.Photo Story
-
Guys sport kilts for women’s cause at PASS Summit
SQL Kilt Day has been turning heads at the PASS Summit lately, with SQL Server professionals ditching pants for Scotland’s signature garment in support of the Women in Technology interest group.Feature
-
PASS Summit 2011 promises news, networking, instruction
PASS Summit 2011 for SQL Server professionals is just around the corner, and expert Denny Cherry gives a sneak preview of what’s in store.Opinion
-
SQLSaturdays pack in SQL Server experts and training, camaraderie
SQL Saturdays are one-day events held throughout the country for SQL Server professionals offering SQL Server training and expert advice.Feature
-
What's the real value of SQL Server certification?
Not all certs are created equal, but changes to Microsoft’s certification track over the past few years have left some database professionals curious about what to pursue.News | Sun Aug 01 00:00:00 EDT 2010
-
Five SQL Server books to watch for in 2010
If your New Year's resolution is to refine your SQL Server knowledge, we've got you covered. From data visualization to robust clustering and mirroring solutions, these five books, scheduled for release in 2010, are a must-read for anyone looking to fine-tune their SQL Server skills or acquire new ones.IT Spotlight
-
SQL Server MVPs give back with new book
Talk about a win-win. A new book gives DBAs and developers the chance to improve their crafts while donating to a good cause.Article | Wed Nov 18 00:00:00 EST 2009
-
DBA career paths could lead to business intelligence
Business intelligence could prove to be an ideal specialty for SQL Server DBAs who feel like they've hit a wall with their current jobs.Article | Mon Nov 02 00:00:00 EST 2009
-
TDWI keynote speaker reveals secrets of DBA career success
Anthony Politano started out as a DBA but made his way up the business ladder. Here, the keynote speaker at next week's TDWI conference explains how he did it.Article | Thu Feb 16 00:00:00 EST 2006
-
Advice for becoming an expert DBA
SQL Server 2005 expert Adam Machanic offers general guidelines for becoming an expert DBA.Ask the Expert
- VIEW MORE ON : Career Advice
-
Microsoft’s SQL Server 2012 has muscle, but database battle is fierce
One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.News | Wed Apr 18 13:35:34 EDT 2012
-
SQL Server vs. MySQL: Syntax differences, similar GUIs
Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.Article | Wed Aug 02 00:00:00 EDT 2006
-
Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users
Using open source databases doesn't have to be an all-or-nothing decision. Most will work just fine alongside SQL Server.Article | Thu Jul 27 00:00:00 EDT 2006
-
SQL Server vs. MySQL
Reviewing costs, functionality and implementation techniques, contributor Serdar Yegulalp compares proprietary SQL Server to open source MySQL.Tip
-
Site offerings at a glance
Here is a quick look at our complete lineup of original content that we update regularly.Article | Tue Mar 01 00:00:00 EST 2005
-
CA swings at Oracle, SQL Server with Ingres
Computer Associates is pitching the mature features and 64-bit support of its open sourced Ingres database at Oracle and Microsoft SQL Server customers.News | Wed Feb 23 00:00:00 EST 2005
-
Former Oracle DBA falls for SQL Server
Meet Kevin Kline, a former Oracle DBA and a current SQL Server expert, and find out why Microsoft gets him all worked up.News | Wed Feb 23 00:00:00 EST 2005
-
Oracle 10g priced to compete with SQL Server
The entry-level version of the new Oracle 10g database comes with a price reduction that could spark intense competition with Microsoft SQL Server.News | Wed Feb 23 00:00:00 EST 2005
-
SQL Server pros aren't charmed by open source
Increased competition from open source hasn't affected SQL pros. DBMS shoppers put cost second to features and support --- two areas where some DBAs say open source is deficient.Article | Mon Oct 18 00:00:00 EDT 2004