Database product installation FAQ

Database product installation FAQ http://www.smooth1.co.uk/installs.html

Currently SQL Server,DB2 10.5,Oracle 12.1.0.2,SAP ASE 16.0,Informix 12.10.FC4


Currently reading…

 

DBA Survivor – Become a Rockstar DBA .

http://msdn.microsoft.com/en-us/library/ms191246(v=sql.120).aspx

All DMVs are under sys schema.

http://msdn.microsoft.com/en-us/library/ms188754.aspx

http://msdn.microsoft.com/en-us/library/ms179984.aspx

Wait stats for memory

- CMEMTHREAD

- LATCH_*

- LCM_M_*

- LOWFAIL_MEMMGR_QUEUE

- RESOURCE_SEMAPHORE_*

- UTIL_PAGE_ALLOC

Wait stats for CPU

- CXPACKET

- EXCHANGE

- EXECSYNC

SQL Profile

http://msdn.microsoft.com/en-us/library/ms175481.aspx

http://msdn.microsoft.com/en-us/library/ms190762.aspx

http://msdn.microsoft.com/en-us/library/ms190793.aspx

 


SQL Server 2012 Tabular Data Model

Documented at http://msdn.microsoft.com/en-us/library/hh212945.aspx

Securing the Tabular BI Semantic Model whitepaper http://msdn.microsoft.com/en-us/library/jj127437.aspx

Securing your tabular model http://blogs.msdn.com/b/cathyk/archive/2011/11/21/securing-your-tabular-model.aspx

Getting started with Tabular Model in SQL Server 2012 http://www.mssqltips.com/sqlservertip/2821/getting-started-with-tabular-model-in-sql-server-2012–part-1/

Roles (SSAS Tabular) http://msdn.microsoft.com/en-us/library/hh213165.aspx – includes row filters and dynamic security.

Perspectives – like views http://msdn.microsoft.com/en-us/library/hh230816%28v=sql.110%29.aspx

BISM – Tabular Security Model http://paultebraak.wordpress.com/2011/09/04/bism-%E2%80%93-tabular-security-model – more on row filters.

Implement Dynamic Security by Using Row Filters http://msdn.microsoft.com/en-us/library/hh479759%28v=SQL.110%29.aspx

(DMV Question)

https://www.linkedin.com/groups/Is-there-DMV-find-all-66097.S.5895157457688211456?view=&item=5895157457688211456&type=member&gid=66097&trk=eml-b2_anet_digest-group_discussions-8-grouppost-disc-0&midToken=AQH48zvduqwTWw&fromEmail=fromEmail&ut=0zOeU5w-MNxCk1


SQL Server 2014 Buffer Pool Extension onto SSD.

SQL Server 2014 Buffer Pool Extension onto SSD – http://www.smooth1.co.uk/sqlserver2014/bpe_ssd.html


Informix 12.10.xC4 is out!

Informix 12.10.xC4 is out! Limit session locks and use multi-tenant databases!


SQL Supper 22nd April 2014 Questions.

1. To install SQL Server 2014 documentation locally?

SSMS -> Help -> Manage Help Settings -> Help Library Manager then choose  Install Content from online

Under SQL Server 2014 Add  Books Online, Developer Reference and Installation.

You can also check for updates online as well.

2. What is new in SQL Server 2014 Integration Services?

As per books online nothing! However Professional Microsoft SQL Server 2014 Integration Services

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Buy from Amazon

does mention 2014 enhancements although it says they are from codeplex and not integrated into the base product yet.

3. What is new in Report Services?

Books Online only mentioned addition of support for Chrome as a browser!

4. What T-SQL enhancements are there in 2014?

This is covered at http://www.smooth1.co.uk/sqlserver2014/t_sql_enhancements.html

5. Resource Governor for physical IO, the IO settings do not appear in SSMS.

If you run ‘script resource pool as’ the settings are visible:

USE [master]
GO

/****** Object:  ResourcePool [PoolAdmin]    Script Date: 05/05/2014 10:17:42 ******/
CREATE RESOURCE POOL [PoolAdmin] WITH(min_cpu_percent=0,
max_cpu_percent=100,
min_memory_percent=0,
max_memory_percent=100,
cap_cpu_percent=100,
AFFINITY SCHEDULER = AUTO
,
min_iops_per_volume=20,
max_iops_per_volume=100)

GO

I have mail Mark Souza (General Manager -Data Platform Group) for an update when these will appear in the properties page.


IBM Informix on POWER7 white paper

IBM Informix on POWER7 White paper – https://www.ibm.com/developerworks/community/wikis/home?lang=en-us#!/wiki/W6461741bf7e8_47d7_89fc_a0a9233f3ca9/page/IBM%20Informix%20on%20POWER7  (from Fernando Nunes).

 


Follow

Get every new post delivered to your Inbox.