Email Alerts
-
Dive deep into SQL Server 2014 in-memory OLTP
Probably the biggest feature of the upcoming release, SQL Server 2014 in-memory OLTP has benefits that DBAs should know about. Learn how to set it up.Tip
-
Top SQL Server stories of 2013
Practical tips about SQL Server 2012 dominate the list of top SQL Server stories on SearchSQLServer this year.Feature
-
Microsoft releases SQL Server 2014 CTP 2
This is the last Community Technology Preview (CTP) for SQL Server until it becomes generally available in the first half of next year.News | 17 Oct 2013
-
How to work around Azure database migration limitations
Performing a successful Azure database migration is no easy task. There are plenty of limitations and missing features, and this is how you make do.Tip
-
Coping with the fast pace of new SQL Server versions
Microsoft has upped the ante, releasing new SQL Server versions at a quicker pace. How will you adapt?Feature
-
SQL 2014 features: Partitioned indexes and memory-optimized tables
In this second of a two-part series on SQL 2014 features, Bob Sheldon dives into partitioned indexes and memory-optimized tables.Tip
-
SQL 2014 features: Extended buffer pool and columnar indexes
Two major SQL Server 2014 features are its ability to extend the buffer pool and its implementing of clustered columnar indexes for improved querying.Tip
-
SQL Server 2014 overview part 2: Availability and scalability features
SQL Server 2014, due out at the end of this year, has availability and scalability features that highlight the database release.Feature
-
SQL Server 2014 overview part 1: In-memory, cloud integration features
SQL Server 2014, due out at the end of this year, has in-memory and cloud integration features that highlight the database release.Feature
-
SQL Server upgrade paths: What to do before, during, after upgrading
Planning your SQL Server upgrade is probably the most important step if you want to avoid problems.Tip
- VIEW MORE ON : Migration and Planning
-
HIPAA compliance and SQL Server: Tricks and tools of the trade
Find out which tools help attain HIPAA compliance. Lena Weiner profiles HIPAA pro Brandon Leach, who explains the steps needed to secure SQL Server.Feature
-
Staying hip to HIPAA regulations: How one DBA stays compliant
How do DBAs who adhere to HIPAA regulations get their jobs done while staying compliant? We asked DBA Brandon Leach for some pointers.Feature
-
Basic SQL Server security best practices
Read this article by Ashish Kumar Mehta to learn the basic SQL Server security best practices everyone should know -- but many forget.Feature
-
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
- VIEW MORE ON : Compliance
-
SQL Server 2012 SP2 due out later this year, and other SQL Server news
Following a request from some SQL Server MVPs, Microsoft has announced that SQL Server 2012 SP2 will come out sometime later this year.News Briefs | 07 Mar 2014
-
How to work around Azure database migration limitations
Performing a successful Azure database migration is no easy task. There are plenty of limitations and missing features, and this is how you make do.Tip
-
Evolution of Windows Azure SQL Database
Learn about latest developments in SQL Azure technology, exploring its benefits and drawbacks in this comprehensive guide.Essential Guide
-
Quiz: How well do you know Windows Azure SQL Database?
Take this brief quiz to test your understanding of SQL Server cloud-based database technology.Quiz
-
SVVP (server virtualization validation program)
SVVP (server virtualization validation program) is a policy that allows administrators running running Windows Server on certified virtualization technologies other than Hyper-V and Microsoft Virtual Server to receive technical support for Windows Server from Microsoft.Definition
-
Guide to SQL Server virtualization best practices
This guide offers discussion of the pros and cons of SQL Server virtualization and tips for successful implementation of virtualization technologies.Essential Guide
-
Diving into the Oracle-Microsoft cloud computing deal
Oracle's getting back to its roots, as SQL Azure bites its fingernails (or does it?) Find out why the Oracle-Microsoft deal matters.News | 24 Jun 2013
-
SQL Server high availability: Natural enemy of virtualization?
Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.Tip
-
SQL Server virtualization: When it's just not a good idea
Virtualizing SQL Server is a good idea for many IT shops, but it's not for everyone. Robert Sheldon explains when it might not be a good choice.Tip
-
Understanding SQL Server virtualization
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do, it’s important to consider myriad of things, including the age of your physical servers, the amount of data to be migrated to the virtual server, the experience of your IT staff and the I/O benefits.E-Handbook
- VIEW MORE ON : Consolidation and Virtualization
-
A good SQL Server DBA resume includes knowing the language of business
Learning how technology affects the business will boost any SQL Server DBA resume out there, according to consultant Chris Presley.Tip
-
Microsoft SQL Server training: What you need to know
Learn about the SQL Server database and how to make the most of SQL Server training in this essential guide.Essential Guide
-
Adam Machanic talks SQL Saturday
We caught up with Adam Machanic, group leader of the New England SQL Server user group, at SQL Saturday Boston. Find out what he shared with us.Video
-
HIPAA compliance and SQL Server: Tricks and tools of the trade
Find out which tools help attain HIPAA compliance. Lena Weiner profiles HIPAA pro Brandon Leach, who explains the steps needed to secure SQL Server.Feature
-
Staying hip to HIPAA regulations: How one DBA stays compliant
How do DBAs who adhere to HIPAA regulations get their jobs done while staying compliant? We asked DBA Brandon Leach for some pointers.Feature
-
Denny Cherry's SQL Server career -- Is freelancing for you?
Denny Cherry has developed an enviable SQL Server career based on freelancing. Find out how he did it by reading this profile.Profile
-
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
- 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