When it comes to implementing a big data strategy in a Microsoft SQL Server shop, you’re generally going to consider one of three strategies. In the first strategy, which I won’t be addressing today, you might choose to tackle your big data architecture by pushing your relational database to its scalability limits, perhaps by making greater use of special features such as SQL Server’s columnstore indexes and special optimizations for BI applications. Read the rest of this article … [Read more...]
DBTA – Microsoft SQL Server and the Big Data Play
Filed Under: BigData, Business Intelligence, Cloud, DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: DBA, DBTA
DBTA – Cloud Computing Enhancements in SQL Server 2014
There’s no doubt that cloud computing is growing due to the strong cost benefits, simplified management, and reduced hosting complexities. So it’s only fitting that we cap this series on the new features of Microsoft’s upcoming SQL Server 2014 (SQL2014) release of their flagship database by going over the highlights for SQL2014’s new cloud computing features. Here’s what SQL2014 will do for you with regards to business cloud computing: Read the rest of this article … [Read more...]
Filed Under: Cloud, Databases, DBTA, NoSQL, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: cloud computing, DBA, NoSQL
DBTA : Business Intelligence Enhancements in SQL Server 2014
Microsoft has been pouring R&D resourcesinto building out its business intelligence (BI) feature set and the upcoming SQL Server 2014 (SQL2014) release will continue that trend. The new release includes enhancements to make data exploration easier, improvements in BI semantic modeling, new offerings to help build and support massive databases and data warehouses, and tools to ensure the quality and consistency of data. Here’s what SQL2014 will do for you with regards to business intelligence: Read the rest of this article … [Read more...]
Filed Under: DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Business Intelligence, DBTA
DBTA – For #SQLFamily, It’s the Most Wonderful Time of the Year!
It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. Here’s a bit of context: I'm writing this article for you in the midst of the biggest gathering of SQL Server professions in any given year, the PASS Summit. One of the most visible activities when attendees get together for the very first time at the registration desk or the assembly hall for the first keynote address is the huge number of hugs, … [Read more...]
Filed Under: DBTA, PASS, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: Career, SQLPASS, SQLSaturday
DBTA – Mission Critical Performance Enhancements in SQL Server 2014
Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.” Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and data integration. Read the rest of my article at http://www.dbta.com/Columns/SQL-Server-Drill-Down/Mission-Critical-Performance-Enhancements-Coming-in-SQL-Server-2014-92530.aspx … [Read more...]
Filed Under: Administration, Databases, DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: DBA, DBTA
DBTA – SQL Server 2014 Overview
Perhaps this is your first time reading my column or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL Server to around one new release every 18 to 24 months. Add in the fact that Microsoft goes to market with their beta releases, better known as Community Technology Preview (CTPs), several months before the official release of the product. That means we could be in for a rush of new features and upgrades every year or so. Wow. Read the rest of my article … [Read more...]
Filed Under: DBTA, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post Tagged With: DBA, DBTA, Developer
Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference
I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee. This year, I'm trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone to see and share. If you attended my session(s) and enjoyed them, feel free to download the content here. But it'd be even better if you also left a few words in the Comment section. Skip below to grab the slide decks. Thanks very much! Enjoy, -Kevin -Follow me on Twitter! -Google Author Microsoft SQL Server Internals & … [Read more...]
Third Party Applications and Other Acts of Violence Against Your SQL Server
I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ticketing apps. I'm not talking about monitoring and tuning applications since they, by their very nature, need a different sort of access to your back-end server resources. (Full disclosure: both Tom and I currently work for different tools vendors. But we're both … [Read more...]
Filed Under: Administration, Databases, On-Line Resources, SQL Server, SQLServerPedia Syndication Tagged With: Best Practices, DBA
Join Me at the Ft. Lauderdale SQL Saturday on June 14, 2014!
Join Me at SQLSaturday #288 in Beautiful Ft. Lauderdale, FL SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 14 2014 at 3301 College Avenue, Davie, FL 33314. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event. Where Is It? This event will be held on Jun 14, 2014 at Nova Southeastern University 3301 College Ave, Davie, FL 33314. You need to go to the Carl … [Read more...]
Filed Under: Conferences, Databases, PASS, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming Tagged With: SQLSaturday, Transact-SQL Programming
Interested in Self-Service Analytics at the PASS Business Analytics Conference?
I don’t know if you’re planning to attend the PASS Business Analytics Conference. But you'll be missing a ton of great content especially for data, analytics, and business intelligence professionals. There's still plenty of time to register and, if you use my discount code – BABS2B – you'll get $150 off the conference registration fee. There will be more than 60 sessions at the event by BA/BI experts from Intuit, Microsoft, SurveyMonkey, Wells Fargo, and more. Last year’s inaugural event was quite the shindig, bringing in around 900 business analysts, data scientists, architects, and BI and … [Read more...]
Filed Under: BigData, Business Analytics, Business Intelligence, Cloud, Conferences, Databases, PASS, Presentations, SQL Server, SQLMag Tagged With: Business Intelligence, SQL Server 2012
