Email Alerts
-
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 | 18 Apr 2012
-
Split root table with T-SQL in SQL Azure Federations
SQL Azure Federations can help manage massive amounts of data, says Roger Jennings. In Part 2 of this two-part series, read on for instructions on splitting the federation root table.Tip
-
Big data a big deal for SQL Server 2012, users say
SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.News | 11 Apr 2012
-
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 | 14 Mar 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 | 12 Mar 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
- VIEW MORE ON : Migration and Planning
-
Eight ways that SQL Server developers hurt performance
Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong.Tip
-
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 | 01 Mar 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
- VIEW MORE ON : Compliance
-
Making sense of SQL Server 2012 virtual environment licensing
SQL Server 2012 licensing is complicated enough. Now add in SQL Server virtual environments and try not to let your head spin.Tip
-
Back up SQL Server to SQL Azure? Some have their fingers crossed
With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases.News | 12 Jun 2012
-
Ahead of TechEd, Microsoft speaks on SQL Server 2012, Amazon RDS
Mark Kromer gives tips on what he thinks will be the best sessions at Microsoft TechEd 2012, and also comments on SQL Server in the cloud and a recent Amazon announcement.Q&A; | 06 Jun 2012
-
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 | 05 Jul 2011
- VIEW MORE ON : Consolidation and Virtualization
-
SQL Server DBA training and resources for the reluctant DBA
As a reluctant DBA, you may not know where to look for SQL Server DBA resources. This tip by SQL Server expert Don Jones points you in the right direction.Tip
-
Ramp up your SMB's BI skills
The next frontier of BI skills is undoubtedly the SMB. Read this tip from expert Don Jones to start preparing now.Tip
-
SQL Server training benefits for non-DBAs
DBAs know the value of SQL Server training. But what are the benefits for non-DBAs? This tip by Serdar Yegulalp examines who should learn more about SQL Server.Tip
-
Jam session at Microsoft TechEd proves geeks can have fun too
Our associate editor, Lena J. Weiner, went to a jam session at Microsoft TechEd on a specific quest: to prove that geeks are the biggest party animals. Read this article to see what she discovered.News | 27 Jun 2012
-
TechEd 101: Scoring some ice cream
Knowing your way around the monstrous Microsoft show isn’t always easy, but three show veterans give their take on what works.News | 11 Jun 2012
-
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 | 01 Aug 2010
- 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 | 18 Apr 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 | 02 Aug 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 | 27 Jul 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 | 01 Mar 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 | 23 Feb 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 | 23 Feb 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 | 23 Feb 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 | 18 Oct 2004