|
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
You might have seen this topic headline (Excel import issue) discussed in many forums, blogs etc. This issue puts a serious limitation to Ms-Excel to be used as a data source. In this post we are going to see conceptually; why the experts are saying so...
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought I would share.
Pour your heart out to answer a question. When someone asks a question, it means they followed your post hoping they would find an answer ...
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
Know everything about SQL Server technologies and latest happenings, not to mention the best practices and sharing best from our own experience....
|
|
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
The below procedure will return the size occupied by the indexes in a table. This will be helpful to measure the size before and after the maintenance activities.
Create Proc SQLZealot_FindIndexSize( @OBJECT_NAME VARCHAR(255) )
As
Begin
DECLARE ...
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
For the next few weeks, the topic of upgrading SSIS 2008 packages to SSIS 2012 will be keeping me very busy. I am preparing to speak on the topic three times at upcoming developer events: SQL Saturday #112, SQL Saturday #132 and TechEd NA 2012.
The most...
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
Last week I was pretty much focusing on setting a lab environment to test SQL 2012 Availability Groups and Failover Cluster Instances.
I had to setup 3 VM’s to play around and out of that one will be a domain controller.
Once all the VM’s we...
|
-
Jacob Sebastian Liked 12 Months ago through Syndicated Blogs | 1 Point
I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows as Parent Child paradigm. Let me tell you, this isn’t new in 2012. There are, however, a few changes to the Execute Package Task. Le...
|
-
Jacob Sebastian Liked 1 Years ago through Syndicated Blogs | 1 Point
Did you knew that we can change the location the “Desktop” folder. Yes! The default location where files/folders are stored is “c:\users\\desktop” and you can change this.
But why do you want to do this?
1.FUN!
2. It’s a go...
|
-
Jacob Sebastian Liked 1 Years ago through Syndicated Blogs | 1 Point
“Sign in with Twitter” is a popular practice to authenticate the users on your website. One advantage compared to an own registration is the lower inhibition for the user. But on the other hand Twitter doesn’t fess up with all the information’s and yo...
|