-
Three tricky questions a BI system can answer
Should a small or medium-sized business 'trust its gut' or get a BI system? Don Jones shows three examples of things you can't determine without BI.
-
Introduction to SQL Server 2012 Express LocalDB
SQL Server 2012 Express LocalDB is a good way for developers to be able to play around with SQL Server 2012. Learn how to install and get started with it.
-
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.
-
Coding for seamless SQL Server database mirroring
SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring.
-
SQL Server stored procedures vs. CLR
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you.
-
Licensing for SQL Server virtual environments
SQL Server 2012 licensing is complicated enough. Now add in SQL Server virtual environments and try not to let your head spin.
-
Managing linked server security in SQL Server
What do you need to know to effectively manage your linked server? Find out in this tip from SQL Server expert Roman Rehak.
-
SQL Server analytic functions can fix problems quickly
With the help of T-SQL analytic functions, we can quickly solve complex analytical tasks. Learn more from SQL Server expert Basit Farooq.
-
Best practices for preventing a SQL injection attack
One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out.
-
SQL Server security and user-defined roles
SQL Server security is a topic on many DBAs' minds. But what are the implications of user-defined roles? Expert Serdar Yegulalp explains.
-
More SSIS tips: Parameters and undoing operations
Learn more new tips and tricks for SSIS from expert Robert Sheldon. Check out the last of a three-part series on changes to this important tool.
-
Business intelligence: Don't give it away
With the various challenges SMBs face, securing their business intelligence efforts may seem unimportant. Not so, says expert Don Jones. Find out why.
-
Connecting to SQL Server when admins are locked out
How do you connect to SQL Server when all admins have been locked out? Read this tip from Ashish Mehta and learn a new SQL Server management trick.
-
Great new SSIS features for BI developers
SQL Server 2012 has many features, but a few make SSIS much easier for BI developers. Check out this tip by expert Robert Sheldon to learn more.
-
SQL Server DBA 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.
-
Different ways to audit SQL Server security
Strong SQL Server security has become a more important part of a robust defense. But what are your options for security auditing?
-
T-SQL tricks for SQL Server 2012: T-SQL statements
In the final part of Robert Sheldon's series on features and tricks in T-SQL, learn about important T-SQL statements like LAG, LEAD and more.
-
What's new in SQL Server Reporting Services 2012
What's different about SQL Server Reporting Services 2012? What are the new features? Read this tip by expert Roman Rehak to find out.
-
T-SQL tricks for SQL Server 2012: T-SQL formatting
Learn the advantages of new T-SQL formatting tools in this third part of expert Robert Sheldon's series on new T-SQL tricks for 2012.
-
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.
-
What to keep in mind when virtualizing SQL Server
Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration.
-
In-memory databases: The implications of integration
How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install.
-
Tips for scaling your BI system...in human terms
BI systems are great...if you can get your employees to use them. How do you make your system scalable? Read this tip from Don Jones to find out.
-
Scale out with Windows Azure SQL Database
Scaling out Azure SQL doesn't have to be a painful process. Microsoft Windows expert Bob Sheldon shows you an easier way with Azure SQL federations.