SQL Server

sqlServer

You may be thinking of upgrading your database soon and have some questions on what SQL Server is.

SQL Server is:
– A relational database management system
– Stores data in tables that can be linked to other tables with keys
– Provides a way for applications to read and write data locally or over a network
– Tools that not only manage data but it also include report writing, data import export, and analysis tools. These are SSRS, SSIS, and SSAS respectively
– Operates using SQL And T-SQL languages
SQL Server also comes in different editions as well:

Features Enterprise Business Intelligence Standard Express1
Maximum number of cores

OS Max

16 cores-DBOS Max-AS&RS2

16 cores

4 cores

Maximum memory utilized per instance

OS Max

128 GB

128 GB

1 GB

Maximum size

524 PB

524 PB

524 PB

10 GB

Programmability (T-SQL, data types, FileTable)

SQL Server Management Studio

Policy-based management

Basic OLTP

Basic security (Separation of duties, basic auditing)

Basic high availability3

Built-in data connectors

Basic data integration (SSIS, designer transforms)

Basic reporting4

Basic corporate BI (Analytics, multidimensional semantic model, data mining)

Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server)

Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining)

Enterprise data management (Data Quality Services, Master Data Services)

Advanced data integration (Fuzzy grouping and lookup, change data capture)

Advanced security (SQL Server audit, transparent data encryption)

Data warehousing (In-memory columnstore, compression, partitioning)

Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering)

Advanced transaction processing (In-memory OLTP)

 

Source: MSDN

 

 

 

The “Cloud”

Cloud basics

So today we keep hearing the buzzword all over the place The “Cloud”.  What is the cloud and how does it affect you as a small business owner?  The cloud is a service orientated technology solution platform in which you pay for services like email, databases, and web servers but only for how much you use them. (more…)

What is Responsive Web Design?

Responsive Web Design On Blackboard

 

“Responsive Web Design.” Have you ever heard of this term?  Well guess what. You’re in luck. I’m here to tell you the basics and where you can go to get started.  Remember back in the 90’s when we wanted to get on the internet, we would have to jump on our Compaq or Dell computer and launch AOL (and for those who are too young to remember what that is, it’s America Online.)  We would type in our screen name and password and then suffer through the piercing sounds of the modem connecting to a server and finally… Viola! We were online! We could launch a web browser and surf the WWW or World Wide Web!

(more…)

Get a Website

design and mobile web services and applications.

Do you think having a web presence is optional? Most small businesses still do… but today in our digital world, a business’s first impression is its website.  Not having a website is a loss of potential business. Let’s go over some of the reasons to have a website:

(more…)

Visit Us On FacebookVisit Us On Linkedin