SQL Server Keyboard Shortcuts
SQL Server Keyboard Shortcuts for Management Studio
SQL Server Management Studio is filled with lots of optional settings that lets you...
2014-08-22 (first published: 2014-08-18)
9,772 reads
Business Intelligence and Enterprise Architecture
Effective Business Intelligence
How Business Intelligence Can Help
Effective business intelligence starts with questions that will help your organization make better decisions. For example,...
2014-08-04
670 reads
5 Tips for Finding SQL Server System Data
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items...
2014-07-23 (first published: 2014-07-17)
9,722 reads
Azure HDInsight – Hadoop in the Cloud
Azure HDInsight Overview
HDInsight is a cloud based implementation hosted in the Microsoft Azure cloud. It enables you to quickly create,...
2014-07-10
494 reads
SQL Server 2014 New Features
SQL Server 2014
Below is a listing of the SQL Server 2014 new features and where you can find more information...
2014-07-02
1,937 reads
Microsoft Azure Data Services
Azure Data Services
Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options. ...
2014-06-21
1,115 reads
ETL vs ELT Data Migration
ETL Process
Reporting databases need to consolidate data from across many applications within an organization. In order to successfully pull data...
2014-06-11
1,506 reads
Languages of Big Data Apache Hadoop
Languages of Big Data
Big Data is here and rapidly growing. If you are just starting to learn about Big Data...
2014-05-26
855 reads
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections are part of the Business Connectivity Services (BCS) that can be...
2014-05-18
1,254 reads
SQL Saturday #308 – Houston TX Presentation
Tabular Data Visualized by Power View
I am presenting this Saturday 5/10/2014 at 4PM at the Houston TX SQL Saturday Event. ...
2014-05-09
701 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers