Windows Azure is part of the Microsoft "stack" - the suite of software and services we offer. Because we have so many products in almost every part of technology, it's hard to know everything about all parts of what we do - even for those of us who work here. ...
SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications.
-
-
How To Find Long Running Backups in SQL Server
I’ve written before about how much I love looking for outliers. One example of this can be found in the post I did on the sysjobhistory table. Recently I was asked to put together some code to find out which backups were “running long”. Of course my first question ...
-
Basic SSIS Equivalents to T-SQL's LIKE
There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another. One of those for you might be the LIKE keyword in T-SQL. LIKE is fairly powerful in T-SQL - it does rudimentary regular expressions. How do you ...
-
Cannot connect to SQL Server
Question: I cannot connect to Sql server remotely from management studio , It is the correct User name and password. Cannot connect to xxxx.xxxx.xxxx.xxxx =================================== A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that ...
-
Wrap Up to t-SQL Tuesday #30
I have to admit. I am a little surprised at all the different opinions that were shared during the t-SQL Tuesday #30 from a couple weeks ago. Let me tell you why… First I have to admit there are times when I look at a situation and I say to ...
-
BIxPress 3.5–Now With More Awesome!
Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a tool that helps you develop SSIS/SSAS solutions faster, easily/quickly deploy SSIS packages, monitor performance SSIS packages and much, much more! So what’s new with 3 ...
-
New Toad for SQL Server Beta
A new beta build of Toad for SQL Server (v5.7.0.527) is available at: http://toadforsqlserver.com/beta.jspa It’s free and, afaik, doesn’t have a short expiration date. It contains popular features such as compare & sync (for database schemas, servers, and data), a full transaction ...
-
What happens when a SSAS Tabular model exceeds memory?
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database in memory (greatly compressing the database). So what happens if your database is too big to fit in memory? You will get this error when you process the model: “The ...
-
How to restore the tail end of a transaction log
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of the log for the database has not been backed up? Many times if you are just restoring a database into a development environment you don’t care so you just ...
-
New Server in an Hour? No Problem! #sqlsat142
If you attended my presentation at SQL Saturday 142 in Waltham, thank you. That may have been the most fun I’ve had presenting to a small group in a while. You were engaged and asked a ton of great questions. I promised that I’d have my presentation and ...