Articles
(Showing 19 Results)
31-Aug-2010
Section: Full Magazine Welcome to the second issue of The SolidQ Journal, featuring a new column on cloud computing from Geoff Snowman and Gilberto Zampatti’s overview of Sharepoint 2010 for DBAs. Plus, don’t miss Greg Low on logins and SIDs, Francesco de Chirico on managing MDX query parameters for reporting, and Herbert Albert and Gianluca Hotz on how to restore database backups with PowerShell. Rounding out the issue is Davide Mauri’s rebuttal to the NoSQL “movement” and a look at Mentor Craig Utley.
30-Aug-2010
Section: Summary Magazine Check out the contents of the August 2010 issue of The SolidQ Journal.
29-Aug-2010
Section: Software Development Having trouble ordering up the right type of cloud service for your organization? The NIST definition of cloud computing - including 3 services models and 4 deployment models - provides a powerful framework for understanding vendors' different cloud offerings.
29-Aug-2010
Section: Database Administration Interested in ways to deal with a common problem when restoring databases from other servers? Answers here!
29-Aug-2010
Section: Meet our mentors An avid photographer, Craig sees solutions to BI problems through many different lenses.
29-Aug-2010
Section: Business Intelligence See how to manage MDX query parameters in a simple and flexible way, especially how to set two fundamental parameter properties - Label and Value - and rename the All member of a hierarchy to better fit your users' reporting needs.
29-Aug-2010
Section: Database Administration See how to use PowerShell to easily restore backups created with a fairly common SQL Server maintenance plan setup.
29-Aug-2010
Section: Database Administration A for more flexible (and scalable) SharePoint architecture comes at a price -a higher administrative burden, especially for DBAs.
29-Aug-2010
Section: ViewPoint Sure, RDBMSs could be improved. But do NoSQL supporters really want to drop the relational model?
19-Jul-2010
Section: Full Magazine Welcome to the launch issue of The SolidQ Journal, featuring an in-depth interview with SQLCAT’s Mark Souza, Craig Utley on how to properly create SSAS dimensions, and Stephen Cohen putting requirements in their place. Plus, don’t miss Greg Low on indexing foreign keys, Ken Spencer on taming the n-tier architecture, Herbert Albert and Gianluca Hotz on getting started with PowerShell, and Mark Tabladillo on why you should use data mining.
18-Jul-2010
Section: Summary Magazine Check out the contents of the July 2010 launch issue of The SolidQ Journal.
17-Jul-2010
Section: Meet our mentors What three events got SolidQ's Performance & Scalability Practice Manager Andrew Kelly to where he is today? Here's his story.
16-Jul-2010
Section: Interview What do you ask the person who wakes up every morning thinking about how to make SQL Server better? How about “What’s the biggest mistake the SQL Server team ever made?” In this interview, Mark Souza, leader of Microsoft’s elite SQL Server Customer Advisory Team (SQLCAT), answers this and other vollies from The SolidQ Journal’s Brian Moran, covering everything from top SQL Server 2008 R2 features and whether the CLR scales to divisions between traditional DBAs and BI folks and what ever happened to the Easter eggs in the management tools.
16-Jul-2010
Section: Database Administration How many times do we struggle to solve a problem using T-SQL when we could probably solve it faster and more efficiently with a language whose main focus is not data manipulation anda database object management? PowerShell can fill this gap.
16-Jul-2010
Section: Software Development Stop treating the needs of your customers as static. Requirements are merely snapshots of the shadows cast by fleeting ideas-good clues, but hardly stable, contractual definitions of success.
16-Jul-2010
Section: Database Administration Although you can usually create better indexes on columns in foreign keys constraints than a default index would provide, the problem is that often no index is created on foreign keys at all.
16-Jul-2010
Section: Business Intelligence Creating dimensions in SQL Server Analysis Services is easy, but creating them properly can be challenging. Failing to create dimensions that adhere to best practices can lead to cubes that are both slow and difficult to browse. Fortunately, learning how to create dimensions that are fast and provide easy analysis for your users is simple, but expect to spend a fair amount of time creating the dimensions and configuring the parameters.
16-Jul-2010
Section: Business Intelligence Data mining might not solve all the world's problems, but here is a real-world look at how Microsoft SQL Server data mining technologies can provide actionable information and answers to common business questions.
14-Jul-2010
Section: Software Development Tame the development process for n-tier applications by adding unit, load, and performace testing as well as performance monitors, logging, and automated deployment.
|
|