SQL Server 2012 – Deprecated Features

This topic describes the deprecated SQL Server Database Engine features that are still available in SQL Server 2012. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

You can monitor the use of deprecated features by using the SQL Server Deprecated Features Object performance counter and trace events. For more information, see Use SQL Server Objects.

Here’s the complete list of deprecated database features in SQL Server 2012:
http://msdn.microsoft.com/en-us/library/ms143729.aspx

Northwind sample database for In-Memory OLTP

You want to use the Hekaton-ized Northwind sample database code from the SQL Server 2014 Books Online?
It’s you’re lucky day, you can download it here:

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

SQL-Server-2014


/*
** Northwind database – In-Memory OLTP version (SQL"14" CTP1)
**
** This database is an adaptation of the Northwind database for In-Memory OLTP
**
** All tables were converted to memory-optimized tables
** Regular tables were added to house the image data that is not suitable for storing in-memory
** Half the stored procedures were migrated to native compiled - the remainder uses interop
**
** Path for the memory_optimized_data filegroup is 'c:\data\'; modify as needed
**
**
** Structure of the script:
**
** 1) create database
** 2) create tables and views
** 3) insert data
** 4) update statistics
** 5) create procedures
**
**
**
** Copyright Microsoft, Inc. 1994 - 2013
** All Rights Reserved.
*/

How to find a column in database (SQL Server)

find_keywords
Want to know where that specific column is located in your database?
Or just want to figure out where that data is stored?





You’re able to locate a specific column by using this query:

SELECT
t.name AS TableName,
SCHEMA_NAME(schema_id) AS SchemaName,
c.name AS ColumnName
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%keyword%'
ORDER BY SchemaName, ColumnName



Since I didn’t want to type it again and again…I made a Stored Procedure (SP) for it:

CREATE PROCEDURE [dbo].[usp_FindColumnInAllTables]
(
@KeyWord NVARCHAR(200)
)
AS

BEGIN

SELECT
t.name AS TableName,
SCHEMA_NAME(schema_id) AS SchemaName,
c.name AS ColumnName
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%'+@KeyWord+'%'
ORDER BY SchemaName, ColumnName

END



Failed scheduled reports in SSRS (Query)

How to find failed SSRS report subscriptions? Which includes the SQL Agent Job Id?
Well, you might want to use this query!


SELECT
c.Name AS Report_Name
,C.Path AS ReportPath
,s.ScheduleID AS JobName
,su.Description AS SubscriptionDescription
,su.LastStatus
,su.LastRunTime
FROM dbo.Schedule s
INNER JOIN dbo.ReportSchedule rs
ON s.ScheduleID = rs.ScheduleID
INNER JOIN dbo.Catalog c
ON rs.ReportID = c.ItemID
INNER JOIN dbo.Subscriptions su
ON rs.SubscriptionID = su.SubscriptionID
WHERE LastStatus LIKE '%Failure%'

Thanks to Thomas Mucha.


SSIS – No status is available (NonColumnSpecificError)

In case your SSIS package fails to insert new records into a destination table and you receive an error message like:

No status is available.
[NonColumnSpecificError]

In my case, the Error Description (custom) component returned this message and wrote it to my errors-table:

SSIS-Error-Description-Component

SSIS-No-Status-Is-Available-NonColumnSpecificError

More info about this component can be found here.

It’s probably a Foreign Key (FK) constraint, you might want to check those.


Power BI for Office 365

Power BI for Office 365 is a cloud-based business intelligence (BI) solution that enables our customers to easily gain insights from their data, working within Excel to analyze and visualize the data in a self-service way.

People love Excel for analyzing data, so we’ve built Power BI for Office 365 right into this experience, making it an even more powerful tool. You may have already seen the Power Pivot and Power View capabilities in Excel and today we continue to extend our BI offerings. Power BI for Office 365 now includes:
Power Query, enabling customers to easily search and access public data and their organization’s data, all within Excel (formerly known as “Data Explorer“).
Power Map, a 3D data visualization tool for mapping, exploring and interacting with geographic and temporal data (formerly known as product codename “Geoflow“).
Power Pivot for creating and customizing flexible data models within Excel.
Power View for creating interactive charts, graphs and other visual representations of data.

Power-BI-for-Office-365-Tablet

We know that it’s not only essential for people to have the ability to easily identify new insights from their data, but also to collaborate and provide access to that data in a trusted environment. That’s why Power BI for Office 365 extends beyond your existing on premise systems to deliver value within an already trusted service, providing:

Power BI sites, dedicated collaborative BI workspaces in Office 365 for sharing data and insights with colleagues. The Power BI sites also keep customers’ data up to date with connectivity and data refresh back to their on premise data sources.
New natural language query capabilities that allow customers to ask questions and get answers. They simply type their question into a dialog box and the system interprets and automatically generates interactive charts and graphs based on available data.
Connected BI experience, dedicated native apps for Windows 8, Windows RT and iPad to stay connected with your reports and data wherever you are as well as HTML5 support for browser based viewing on any device.

Nice huh? Don’t forget:

Power Map (formally known as ‘Geoflow’)

Power-BI-for-Office-365-Power-Map-Geoflow

Power View in SharePoint

Power-BI-for-Office-365-Power-View

Microsoft Power BI for Windows or Microsoft Power BI for iPad

Power-BI-for-Windows

Want to signup for the preview this summer?

Power-BI-for-Office-365-Signup-Preview

Thanks to Chris Webb:
http://cwebbbi.wordpress.com/2013/07/08/some-thoughts-about-power-bi/

More info about Microsoft Power BI?:
http://blogs.office.com/b/office-news/archive/2013/07/08/announcing-power-bi-for-office-365.aspx
http://blogs.office.com/b/office365tech/archive/2013/07/07/what-powers-power-bi-in-office-365.aspx
http://blogs.technet.com/b/dataplatforminsider/archive/2013/07/08/introducing-power-bi-for-office-365.aspx
http://office.microsoft.com/en-us/excel/power-bi-FX104080667.aspx
http://blogs.msdn.com/b/powerbi/archive/2013/07/07/getting-started-with-pq-and-pm.aspx



Join us at LinkedIn!
Don’t forget to join the ‘Microsoft Power BI‘ group on LinkedIn and stay updated!:
linkedin-microsoft-power-bi-group