Blogs

SQL Server 2012: Tabular Models vs PowerPivot Models

In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the Business Intelligence Semantic Model (BISM). BISM also includes the multidimensional model (formally called the UDM). The Tabular model is based...

Posted to Community blogs by James Serra on 03-14-2012

Filed under: Powerpivot, SQLServerPedia Syndication, SQL Server 2012

Houston Area SQL Server User Group Presentation

Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG . Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes As a followup to a question from the presentation about clustering...

Posted to Community blogs by James Serra on 03-13-2012

Filed under: Career, Appliance, Session, Presentation

DBA supertech . Specialise or generalise?

Specialise or a generalise? It all depends on how you define these terms. A SQL Server DBA may be considered to be a specialist by a Enterprise Architect but a generalist by a SSIS expert . The DBA is currently in great demand and based on predictions...

Posted to Jack Vamvas's Blog by Jack Vamvas on 03-13-2012

Filed under: DBA

Factors that can delay Log Truncation – LOG BACKUP

When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs to fill. This can lead to a Error 9002 In the Full Recovery mode , a Log Backup will delete the commited transaction log records...

Posted to Jack Vamvas's Blog by Jack Vamvas on 03-12-2012

Filed under: transaction logs, Backup and Restore

Data Warehouse Architecture – Kimball and Inmon methodologies

What is the best methodology to use when creating a data warehouse ? Well, first off, let’s discuss some of the reasons why you would want to use a data warehouse and not just use your operational system: You need to integrate many different sources...

Posted to Community blogs by James Serra on 03-12-2012

Filed under: SQLServerPedia Syndication, Data warehouse

#0142 - SQL Server – Profiler - Part 09 - Introducing the SQLDiag utility to capture SQL and Performance traces

In one of the earlier parts of this tutorial series ( Part 06 ), I had demonstrated how to correlate the SQL Profiler trace with the Windows Performance Logs. I had used two utilities for the demonstration – the SQL Server Profiler and the Windows Reliability...

Posted to Nakul's Blog by Nakul Vachhrajani on 03-11-2012

Filed under: Administration, Performance Tuning, Tips, SQL Server, #SQLServer, Guidance, DBA, Tools and Utilities, Series

Heat Maps for SSRS using Map Control

I have always been inspired by a particular quote from Arthur C Clarke - “ The only way of finding the limits of the possible is by going beyond them into the impossible ”. The more you think of it, the more you make sense out of it. If you decide in...

Posted to Some Random Thoughts by Jason Thomas on 03-11-2012

Filed under: SSRS, MSBI, SQLServer, #SSRS, #SQLServer, BI

Dynamic Order by issue

Today one of my friend ask me, can we use Order by clause dynamically ? I said yes, but there are few limitations while using case in order by clause see the below example. This script will return Error: DECLARE @TOP INT = 10, @FLD VARCHAR(20)='AGENT_ID'...

Posted to Raghunath Bhandari's Blog by Raghunath Bhandari on 03-11-2012

Filed under: Database, SQL server, Tricks, Tips, MSSQ, Raghu, Dynamic Order by issue

SQL Server 2012 Beta Exams Are Now Available

Just checked Prometric and all the SQL Server 2012 Beta exams are available for booking. Perfect timing as I’m attending SQL Connections in Las Vegas at the end of March and have also signed up for the 2 day pre-conference workshop on SQL Server...

Posted to Mr Wharty's Ramblings by Jeff Wharton on 03-09-2012

Filed under: Certification, SQL Server 2012

SQL Server - Kerberos and KRB_AP_ERR_MODIFIED

On a routine scan of Event Viewer System, Logs I found this message on 4 different servers hosting SQL Server installations The kerberos client received a KRB_AP_ERR_MODIFIED error from the server MYCOMPUTER$. This indicates that the password used to...

Posted to Jack Vamvas's Blog by Jack Vamvas on 03-09-2012

Filed under: Security Management, Event Log

SQL Server 2012 (“Denali”): Power View installation and requirements

Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting Services Add-in for SharePoint Products”. This is a newer version of the add-in that is installed with SharePoint 2010, with...

Posted to Community blogs by James Serra on 03-09-2012

Filed under: SQLServerPedia Syndication, SQL Server 2012, Power View/Project Crescent

Microsoft Virtual Academy – New SQL Server 2012 Content Released

Microsoft has released 5 new SQL Server 2012 Microsoft Virtual Academy courses. Breakthrough Insights using Microsoft SQL Server 2012 - Analysis Services The 7 modules of this course will introduce you to concepts and practices such as: Developing and...

Posted to Mr Wharty's Ramblings by Jeff Wharton on 03-08-2012

Filed under: SQL Server 2012, Training, Microsoft Virtual Academy

Certification: Yes….No….Maybe!

I read an interesting article by Paul Randal the other day on whether certification was worth it ( How valuable are certifications ) and it got me thinking about whether Microsoft was serious about certification or does the program exist purely to “keep...

Posted to Mr Wharty's Ramblings by Jeff Wharton on 03-08-2012

Filed under: Certification, SQL Server 2012, Training

SQL Server – netstat monitoring and tuning performance

To display network connections and various network interface statistics – netstat is a handy command – line based tool. Why is it useful for the DBA ? Execute netstat –an to view all active connections (TCP and UDP ports) on a server...

Posted to Jack Vamvas's Blog by Jack Vamvas on 03-08-2012

Filed under: performance, Monitor Performance, Network

#0141 - SQL Server – Profiler - Part 08 - Run a SQL Trace via T-SQL code (Part B)

In my previous post in this tutorial ( here ), I introduced the system stored procedures that would allow us to create a SQL Trace, define events and data columns to capture and start the trace using nothing but pure T-SQL code. Today, we will see the...

Posted to Nakul's Blog by Nakul Vachhrajani on 03-07-2012

Filed under: Administration, T-SQL, Tips, SQL Server, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Series

Tags