Blair Greenwood is an associate editor for SQL Server Pro, where she extensively covers database administration, development, and business intelligence industry trends and news. Follow her on Twitter at @blair_greenwood and Google+.
Ahead of the Microsoft TechEd 2014 conference, Melissa Data announced that they will be showing off new matching and de-duplication functionality in the company's MatchUp Component for SQL Server Integration Services (SSIS).
Tim Ford is involved in several different facets of the SQL Server space. Not only is he heavily involved in our own IT/Dev Connections conference, but he's also the person behind the annual SQL Cruise technical training event.
Microsoft is cleaning house by replacing its current cloud-database service tiers with new ones. According to the company, it is retiring its SQL Database Web and Business service tiers on April 24, 2015.
During Microsoft's Q3 earnings call yesterday, the company generated a net income of $5.66 billion on revenues of $20.40 billion. Additionally, the Devices and Consumer sector within Microsoft grew 12 percent to $8.30 billion, and commercial revenue grew 7 percent to $12.23 billion.
Code like this isn’t optimal:
IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')
DROP TABLE TableToDrop;
Neither is this:
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')
DROP TABLE TableToDrop;
Yet, I see both of those used all of the time – over and over again. Even though it’s 2015. ...More
This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....More