Excel şifresi kırma - Unprotect Worksheet

27 Kas 2013 In: hoş, ipucu
Open your protected Excel file and press ALT+F11.
 
Copy and Paste below code
 
Just press F5, you will see new password of your file.
 
Sub GiveNewPasswordOnce()
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "New password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub 

What Most Schools Don’t Teach?

26 Kas 2013 In: hoş, öneri
  • “Everybody in this country should learn how to program a computer
    because it teaches you how to think.” 
    — STEVE JOBS, THE LOST INTERVIEW

Android de yazıcı kullanımı

22 Kas 2013 In:

Merhabalar Android geliştiridiginiz bir uygulama içinde yazıcı çıktısı almanız gerekiyorsa, çok fazla seçenek yok . Nedense bu konu çok bakir kalmış bununla ilgili bir cihaz aldım ama ilgilenecek vakit olmadı, amacım bunu ucuz yoldan çözmek. Ve mevcut yazıcıları kullanılabilir kılmak. Örnegin EPSON LX300, LX-300+ gibi.

Aldıgım bu Bluetooth dan seriye çevirici : http://www.dx.com/p/jy-mcu-arduino-bluetooth-wireless-serial-port-module-104299 bence bunla çözülür test etmek lazım.

 

 

 
Neyse ben bunla uğraşmaktansa etiket veya fiş basmak için  aşagıdaki cihazı aldım :
 
 Sewoo LK-P20
 
Kendisi bluetooth dan baglanıyor SDK sı var, çok zor olmadı. Bluetooth u açma, cihaz arama, eşleştirme, ilgili cihaza veri gönderme, feedback alma, şifre değiştirme işlemlleri fln kolayca oldu. Mikro, NETSİS veya Logo ya entegre ettigimi uygulmalarda fatura basmak için yetersiz, termal oldugu için.
 
Kendisi burada :
 
 

ASP.NET inline expressions

17 Kas 2013 In: .net, ipucu
  • <% ... %>
  • <%= ... %>
  • <%@ ... %>
  • <%# ... %>
  • <%$ ... %>
  • <%-- ... %>
  • <%@ ... %>
 

<% ... %> embedded code blocks

The embedded code block is used to preserve backward compatibility with classical ASP. The code in the block can execute programming statements and call functions in the current page class during the page-rendering phase.

The following example demonstrates an ASP.NET page that has sample Microsoft Visual Basic .NET code in an embedded code block to display the results of a loop:
<%@ Page Language="VB" %>
<html>
<body>
<form id="form1" runat="server">
<% For i As Integer = 16 To 24 Step 2%>
<div style="font-size: <% Response.Write(i)%>">
Hello World<br />
</div>
<% Next%>
</form>
</body>
</html>
Because an embedded code block is always mixed with the HTML source, it is difficult for developers to read and maintain them. 

For more information about embedded code blocks in ASP.NET Web pages, visit the following Microsoft Developer Network (MSDN) Web site:

<%= ... %> displaying expression

The <%= ... %>displaying expression is an equivalent of the embedded code block that contains only the Response.Write(…) statement. This is the simplest way to display information such as a single string, an int variable, or a constant. 

For example, the following sample code displays the current time:
<%@ Page Language="VB" %>
<html>
<body>
<form id="form1" runat="server">
<%=DateTime.Now.ToString() %>
</form>
</body>
</html>
Remember that the displaying expression cannot be used in the attributes of server controls. This is because the .NET Framework directly compiles the whole expression instead of the displaying content as the value to the attribute.

For more information about how to display information from ASP.NET, visit the following MSDN Web site:

<%@ ... %> directive expression

The directive expression is the syntax that specifies settings that are used by the page and by user control compilers when they process ASP.NET Web Form (.aspx) pages and User Control (.ascx) files.

The ASP.NET page framework supports the following directives:
@ Page Defines page-specific attributes that are used by the ASP.NET page parser and compiler. Can be included only in .aspx files. 
*This directive name can be used only in ASP.NET Web Form pages.
@ Control Defines control-specific attributes that are used by the ASP.NET page parser and compiler. Can be included only in .ascx files (user controls). 
*This directive name can be used only in User Control files.
@ Import Explicitly imports a namespace into a page or into a user control.
@ Implements Declaratively indicates that a page or a user control implements a specified .NET Framework interface.
@ Register Associates aliases with namespaces and with class names. This enables user controls and custom server controls to be rendered when they are included in a requested page or user control.
@ Assembly Links an assembly to the current page during compilation. It makes all the assembly's classes and interfaces available for use on the page.
@ Master Identifies an ASP.NET master page.
@ WebHandler Identifies an ASP.NET IHttpHandler page.
@ PreviousPageType Provides a way to obtain strong typing against the previous page as accessed through the PreviousPageproperty.
@ MasterType Assigns a class name to the Master property of an ASP.NET page. Provides a way to create a strongly typed reference to the ASP.NET master page.
@ OutputCache Declaratively controls the output caching policies of a page or of a user control.
@ Reference Declaratively links a page or user control to the current page or user control.
For more information about directive syntax, visit the following MSDN Web site:

<%# ... %> data-binding expression

The data-binding expression creates binding between a server control property and a data source when the control’s DataBindmethod of this server control is called on the page. 

The following example shows how to use the data-binding expression to bind the string from a function to the Text property of a label:
<%@ Page Language="VB" %>
<script runat="server">
Protected Function SayHello() As String
Return "Hello World"
End Function
Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs)
lblHello.DataBind()
End Sub
</script>
<html>
<body>
<form id="form1" runat="server">
<asp:Label ID="lblHello" runat="server" Text="<%# SayHello%>"></asp:Label>
</form>
</body>
</html>
For more information about data-binding expression syntax, visit the following MSDN Web site:

<%$ ... %> expression builder

The expression builder is used to set values of control properties based on the information that is contained in an application's configuration or resource files. The following is the basic syntax of the expression builder:
<%$ Expression Prefix: Expression Value %>
The dollar sign ($) indicates to ASP.NET that the following expression is an expression builder. The expression prefix defines the kind of expression, such as AppSettingsConnectionStrings, or Resources. Additionally, you can create and define your own expression builder. The expression value that follows the colon (:) is what ASP.NET will actually use as the value of a certain property.

The following demo shows how to use the expression builder to obtain the copyright of a Web site from the AppSettings node in the Web.config file and how to then set the copyright information as the value of the Literal’s Text property.

The AppSettings node in Web.config file:
<appSettings>
<add key="copyright" value="(c) Copyright 2009 WebSiteName.com"/>
</appSettings>
The expression builder in the ASP.NET Web Form page:
<div id="footer">
<asp:Literal ID="Literal1" runat="server" Text="<%$ AppSettings: copyright %>"></asp:Literal>
</div>
For more information about ASP.NET expressions, visit the following MSDN Web site:

<%-- ... -- %> server-side comments block

The server-side comments block lets developers embed code comments in any location of the HTML source of ASP.NET Web Form pages (except for within <script> code blocks). Any content between the opening and closing tags of the server-side comments block will not be processed on the server or rendered on the resulting page.

The following code example shows how to use the server-side comments block in an ASP.NET page:
<%@ Page Language="VB" %>
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strName As String
strName = Session("userName")
lblUserName.Text = strName
End Sub
</script>
<html>
<body>
<form id="form1" runat="server">
<%-- Label for UserName --%>
<asp:Label ID="lblUserName" runat="server" Text=""></asp:Label>
</form>
</body>
</html>
 

 Başka bir kaynakdan : 

 
 
 <%      %>

these tags what we talk about. It comes from ASP classic style and it used in PHP and JSP too for the same reason "Writing Server Side Code ".

Note: you must know that we can't use it in code behind (Page.aspx.cs ) .

inline Code and  Page Life cycle :

When the page call its Render Method after the PreRenderComplete Event completed the compiler will Execute this Code and embedded it into Render method which accept HtmlTextWriter  as a single parameter  like the following :

protected override void Render(HtmlTextWriter writer)
 {
     base.Render(writer);
}

Let us see the forms you may have seen:

 Page Directive

<%@ Page Language="C#"  %>

Rendering Code

<% Response.Write("Hello World!");  %>

<%= SayHello("Ahmed") %>

<%: DateTime.Now.ToString()  %>

Expression Syntax

<%$ ConnectionStrings:ConnStrFromWebConfig  %>

<%$ AppSettings:ValueFromWebConfig  %>

<%$ Resources:Resource, Arabic  %>

<%$ RouteValue:year  %>

<%$ YourExpressionPrefix : Any   %>

Data Binding  Syntax

<%# Eval("Name")  %>

<%# Bind("Name")  %>

<%# XPath ("Name")  %>

Comment Server

<%-- <asp:Label runat="server" Text="Label"></asp:Label>-- %>

Let us do it in details :

Directive

We use directive to specify settings used by page and user control Compiler . we use it to say hi complier this file is ...... .each directive can have number of attributes as you need.

each directive start with @ . ASP.Net introduced number of Directive as following :

@Page
 : used on .aspx files only and you can use only one  directive inside a file . 

<%
@ Page Language="C#" %>

<%@ Page Language="C#" CodeFile="Default2.aspx.cs" Inherits="Default2"  %>

Note that we are  using Codefile to pass the file name of code behind and inherits to pass class Name.

 

@Control : used only in .ascx files (user control)

<%@ Control Language="C#" ClassName="WebUserControl"  %>

 

@Import :  used for name space declaration and only when we write code inside script tags,I mean that if we use code behind we don't need it because we will use "Using Directive" (C#) or " Imports " (VB.net)

<%@ Import Namespace="System.Data"  %>

 

@Assembly :  used to Links an Assembly(.DLL or .CS and .VB ) to that page and user control .

DLL files like this

<%@ Assembly Name="CustomFile"  %>

(without .dll extension )

Class files like this :

<%@ Assembly src="Csharp.cs"   %>

<%@ Assembly src="Csharp.vb"   %>

Note: we are using Name attribute with dll files and src with class files.

 

@Register : used to register Controls (User Controls and Custom Server Controls) to page and user control.

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp"  %>

<%@ Register src="WebUserControl.ascx"   tagname="WebUserControl" tagprefix="uc1" %>

 

Note :we are using Name attribute when using assembly and using src when user control.

@Implements : used when we want to implement an Interface . and this Directive  takes only one attribute "Interface" .

<%@ Implements Interface="IWebParts"  %>

 

@Reference : used to indicate that the source file of the page or user control  should dynamically compiled and linked to the current page .

<%@ Reference Control ="~/WebUserControl.ascx"  %>

<%@ Reference Page="~/Default2.aspx"  %>

<%@ Reference VirtualPath ="anyfile.any"  %>

 

@OutPutCache : used when we need to put a page or user control in the cache.

<%@ OutputCache Duration ="900" VaryByParam ="none"  %>

Note: both attributes ( Duration and VarybyParam ) are required .

 

@Master : used to decalre page as Master page.

<%@ Master Language="C#"  %>

 

@MasterType : used to reference Master Page when we need to access master page through  Master Property .

<%@ MasterType VirtualPath ="~/MasterPage.master"   %>

 

@PreviousPage : used when need to access previous page through PreviousPage Property .

<%@ PreviousPageType VirtualPath ="~/Default4.aspx"   %>

 

@Application : used to declare the global application file .(global.asax)

<%@ Application Language="C#"   %>

 

@WebService : used to declare the web service file .(.asmx)

<%@ WebService Language="C#" CodeBehind="~/App_Code/WebService.cs" Class="WebService"   %>

 

@WebHandler: used to declare the generic handler file (.ashx)

<%@ WebHandler Language="C#" Class="Handler"  %>

 

@ServiceHost : used by WCF (Windows Communication Foundation) .

<%@ ServiceHost Language="C#" Debug="true" Service="Service" CodeBehind="~/App_Code/Service.cs" %>

 

Rendering Code

Render code tags like Response.write Method. Here an example : using for Looping

    <div>

         <% for(int i = 0 ; i <5; i++){  %>

             Hello World ! <br />

           <%  } %>

    </div>

output the following :

Hello World !

Hello World !

Hello World !

Hello World !

Hello World !

 you can use it to execute a method but this time we use " = " to get out of Response.write to an Expression and =  is used to resolve an expression and return its value to the block

<%@ Page Language="C#"   %>

<script runat="server">

    string message = "I Can Do it ";


    string SayHello(string name)
    {
        return "Hello  " + name;
    }   

</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Test Page </title>

</head>

<body>

    <form id="form1" runat="server">

    <div>
         <%= SayHello("Ahmed") %>
         <br />
         <br />
         <%="Message variable = " + message %>
    </div>
   </form>
</body>
</html>

it will output string say "Hello Ahmed " and also gets the value of message variable .

Note : this code blocks render nothing (no html controls ) . try it yourself . browse this code in the browser and Right click to View source .

Html Encoding output in ASP.Net 4

It provides a concise way to automatically HTML encode content and then render it as output

  <%:DateTime.Now.ToString () %>

You can learn more here :

we can also use it to embedded Server Side code in Client Side Code (Java Script)

what about calling Server side Method from Client Side Method . Let us do it :

take a look at this code

<%@ Page Language="C#"   %>

<script runat="server">
    string SayHello(string name)
    {
        return "Hello  " + name;
    }    
</script>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">
    <title>Test Page </title>
    <script type="text/javascript" >
        function SayAny() {
            alert(' <%= SayHello("ahmed") %>');
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
         <br />
        <input type="submit" onclick="SayAny()" value="Say Hello" />
        <br />
    </div>
    </form>
</body>
</html>

 it do what you expect : showing alert message .

Sometimes we have a problem when passig control id to client side code like this

var txt = document.getElementById("TextBox1");

and this happened when we work with container like master page or when we want to find control inside Data contorls Like GridView ,DataList ,Repeater ,and so on. this happens because the control has been changed to something like "container_ControlId". and to solve this issue we can use server side blocks like the following :

var txt = document.getElementById("<%=TextBox1.ClientID %>");

you can use alert message to display the value of this TextBox like this :

alert(txt.value);

Expression Syntax :

Get Connection String Section :

<%$ ConnectionStrings:ConnStrFromWebConfig %>

after we set connection strings in web.config file then we need to use data source controls ,Like the following :

Example

<asp:SqlDataSource ID="SqlDataSource2"   runat="server"  ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT * FROM [Categories]">
</asp:SqlDataSource>

Notice: connectionstring is the name of connection string section inside Web.Config Like following :

Web.config :
<connectionStrings>
    <add name="ConnectionString" 
            connectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;
                                        Integrated Security=True;User Instance=True"
            providerName = "System.Data.SqlClient" />
 </connectionStrings>

Get AppSettings Section 

<%$ AppSettings:ValueFromWebConfig %>

after we set AppSettings section in web.config file you can call it using key name to return its value .

Web.config 

<appSettings>
        <add key ="KeyName" value ="This Value Is Ahmed"/>
</appSettings>

Default.aspx

<asp:Label Text="<%$ AppSettings :Keyname  %>" runat="server" />

Get a value from Global Resource File (.resx )

<%$ Resources:Resource, Arabic  %>

Let us take an example switching between two Language (Arabic and English ).

  • Create two files (Resource.resx , Resource.ar-eg.resx ) and put them in App_GlobalResources folder.
  • Define a key with name "Greeting" in both resource files.

              Note : the "greeting" key will have two different value for Arabic and English .

  • Create test page.aspx and drag a label control and drop down list control. so ,your aspx code will be like this :

<div>
    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
       <asp:ListItem Value="ar-eg">Arabic</asp:ListItem>
       <asp:ListItem Value="en-us">English</asp:ListItem>
    </asp:DropDownList>
    <br />
    <br />
    <asp:Label ID="Label1" runat="server" Text="<%$ Resources:Resource, Greeting %>"> </asp:Label>    
</div>

Note :

Resources >> Say " I am working with resource files ".

Resource >> say "I am the resource file name without extension".

Greeting >> say " I am the Key which my value will be displayed"

now we have two values for "Arabic" and "English" we can switch between them. what will happen if we select English or Arabic ? ok, we need some code to change Language and Current Culture .let us go to next step:

  • We need to override IntializeCulture Method as following :

protected override void InitializeCulture()
    {
        if (Request["DropDownlist1"] != null)
       {
            string lang = Request["DropDownlist1"];
            Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(lang );
            Thread.CurrentThread.CurrentUICulture = System.Globalization.CultureInfo.CreateSpecificCulture(lang );
        }
    }

Now you can select your Language from drop down list control and see that the related content will be displayed.

Routing

ASP.Net Routing is something about mapping URLs, Routing is available in ASP.Net web forms and ASP.Net MVC.Since .net framework 3.5. to use routing you need to create static method that take a parameter of RouteCollection data type inside global.asax file, then call these method in Application_Start event .

May you need more in Routing  so here you can take a look

http://msdn.microsoft.com/en-us/library/dd329551.aspx

Ok , what we want to say is we can use Expression Syntax to set URLs Like this :

<%$ RouteUrl:action=Edit , CategoryName=Cars%>

<%$ RouteValue:year %>

You need to understand what action and categoryName means? To do this refer to The above Link .

Exrpression Builder

<%$ YourExpressionPrefix : Any   %>

yes ,  you can create your Expression like mine : 
<div>
   <asp:Label Text="<%$ myCode:DateTime.Now %>" runat="server" />
</div>

to learn more about Expression Builder Click Here

Data Binding Syntax

<%# Eval("Name") %>

<%# Bind("Name")%>

<%# XPath ("Name") %>

We use embedded code in Data binding to set or get or in Other words to read and write to a data source .we have Two methods for  working with Data base (Eval and Bind ) and one for working with XML (XPath that stand of xml path ) .so , what is the different between Eval and bind ? Eval method is One way that means it is for reading and Bind method is Two way that means it is for Reading and writing  .

Example :  using eval method in grid view to display Images .

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">

        <Columns>

            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />

            <asp:TemplateField>

                <ItemTemplate>

                    <asp:Image ID="Image2" runat="server" ImageUrl='<%# Eval("Path")  %>' Width="70" />

                </ItemTemplate>

            </asp:TemplateField>

        </Columns>

    </asp:GridView>

In the above example we use eval method to get path field from data base and pass It to ImageUrl Property.

try to use bind method in editing data.

XPath method:

Use it when working with Xml, we can use it to select element or attribute and get its value and it comes in many forms Like this :

Look at this file.xml. we use it to simplifies the following :

<?xml version="1.0" encoding="utf-8" ?>
<Links>
    <Link>
       <name>Microsoft</name>
       <Site>http://www.microsoft.com</Site>
   </Link>
   <Link>
       <name id="10" >Asp.net</name>
       <Site>http://www.asp.net</Site>
   </Link>
    <Link>
        <name id="20" >MSDN</name>
        <Site>http://www.msdn.com</Site>
    </Link>
</Links>   

<%# XPath ("Name") %>

get the value of the Name element .

output here will be as following : Microsot  ASP.Net  MSDN

<%# XPath("name[@id]") %>

Get the value of the name element which take an attribute  with name "Id"

output here will be as following : ASP.Net  MSDN

<%# XPath ("name[@id=\"10\"]") %>

Get the value of name element which take an attribute with name id that its value equal 10 .

 

output here will be as following : ASP.Net 

<%# XPath("name/@id") %>

Get the value of  Every  attribute which its name is 'id' that  was defined in "name" element .

output here will be as following : 10  20

Yes, it is give xml more funs .

Note :

When using your custom method as Binding Expression Remember to call Databind Method . this question I meet it in Asp.Net forums and that is my answer "call Databind method to that control "

Example : Get Text  from the result of custom method .

<div>

      <asp:Button ID="SomethingBtn" Text="<%# ServerSideMethod()  %>" runat="server" />

</div>

So when we try to view it in browser the button wouldn't display any text . because we need to call Data bind method for that button Like this :

protected void Page_Load(object sender, EventArgs e)

    {

        Somethingbtn.DataBind();

    }

And finally I want to say that you can use all or one of them Like this :

<%# Eval("Id","~/default.aspx?id={0}")  %>

<%# "Your Name Is :" + Eval("Name") %>

<%# SayHello( Eval("Name").ToString () ) %>

And More ...........

Last thing is Comment Server 

We can use it to put  a comment where the comment is not allowed  .

Example :

<div>

<%-- <asp:Button ID="Button2" runat="server" Text="Button"  />--%>

</div>

 Resource : Ahmed Moosa

 
 
 
 
Repeater içerisinde Visible kontrolu için  Visible='<%# string.Equals(Session["state"].ToString(), "A")%>' 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

SQL Server Versiyonları

9 Kas 2013 In: ipucu
SQL Server 2012 Express Edition
https://www.microsoft.com/en-us/download/details.aspx?id=29062 
ENU\x64\SQLEXPR_x64_ENU.exe
ENU\x64\SQLManagementStudio_x64_ENU.exe
 
 
 
SQL Server 2012
Version
Build
KB
Release Date
11.0.3368.0 
KB2833645
May 2013 
11.0.3349.0 
KB2812412
March 2013 
11.0.3339.0 
KB2790947
January 2013 
11.0.3321.0 
KB2765331
November 2012 
11.0.3000.0 
KB2674317
November 2012 
11.0.2395.0 
KB2777772
December 2012 
11.0.2383.0 
KB2758687
September 2012 
11.0.2332.0 
KB2723749
August 2012 
11.0.2325.0 
KB2703275
June 2012 
11.0.2316.0 
KB2679368
April 2012 
RTM 11.0.2100.60   March 2011
 
 

SQL Server 2008 R2
Version
Build
KB
Release Date
10.50.4279
KB2830140
April 2013
10.50.4276
KB2797460
February 2013
10.50.4270
KB2777358
December 2012
10.50.4266
KB2754552
October 2012
10.50.4263
KB2740411
August 2012
10.50.4260
KB2720425
August 2012
10.50.4000
KB2630458
July 2012
10.50.2868
KB2783135
December 2012
10.50.2817
KB2723743
August 2012
10.50.2822
KB2703282
June 2012
10.50.2811
KB2679367
April, 2012
10.50.2806
KB2659694
February 2012
10.50.2796
KB2633146
December 2011
10.50.2789
KB2591748
October 2011
10.50.2772
KB2567714
August 2011
10.50.2769
KB2544793
July 2011
10.50.2500
KB2527041
July 2011
10.50.1817
KB2703280
June 2012
10.50.1815
KB2679366
April 2012
10.50.1810
KB2659692
March 2012
10.50.1809
KB2633145
February 2012
10.50.1807
KB2591746
October 2011
10.50.1804
KB2567713
August 2011
10.50.1797
KB2534352
June 2011
10.50.1777
KB2507770
April 2011
10.5.1765
KB2489376
February 2011
10.5.1753
KB2438347
December 2010
10.5.1746 
KB2345451
October 2010 
10.5.1734
KB2261464
August 2010
10.5.1720
KB2072493
June 2010
10.5.1702
KB981355
May 2010
RTM
10.5.1600
 
April 2010


SQL Server 2008
Version
Build
KB
Release Date
10.00.5840
KB2834048
May 2013
10.00.5835
KB2814783
March 2013
10.00.5829
KB2799883
January 2013
10.00.5828
KB2771833
November 2012
10.00.5794
KB2738350
September 2012
10.00.5788
KB2715953
July 2012
10.00.5785
KB2696626
May 2012
10.00.5775
KB2673383
March 2012
10.00.5770
KB2648098
Januaury 2012
10.00.5768
KB2633143
November 2011
10.00.5766
KB2617146
October 2011
10.00.5500
KB2546951
October 2011
10.00.4332
KB2696625
May 2012
10.00.4330 KB2673382
March 2012
10.00.4326
KB2648096
January 2012
10.00.4323
KB2617148
November 2011
10.00.4321
KB2582285
September 2011
10.00.4316
KB2555408
July 2011
10.00.4285
KB2527180
May 2011
10.00.4279
KB2498535
March 2011
10.00.4272
KB2467239
January 2011
10.00.4266
KB2289254
November 2010
10.00.4000
KB2285068
September 2010
10.00.2850
KB2582282
September 2011
10.00.2847
KB2555406
July 2011
10.00.2821
KB2527187
May 2011
10.00.2816
KB2497673
March 2011
10.00.2808
KB2467236
January 2011
10.00.2804
KB2413738
November 2010
10.00.2799
KB2279604
September 2010
10.00.2789
KB2083921
July 2010
10.00.2775
KB981702
May 2010
10.00.2766
KB979065
March 2010
10.00.2757
KB977443
January 2010
10.00.2746
KB975977
November 2009
10.00.2734
KB973602
September 2009
10.00.2723
KB971491
July 2009
10.00.2714
KB970315
May 2009
10.00.2710
KB969099
April 2009
10.00.2531
KB968369
April 2009
10.00.1835
KB979064
March 2010
10.00.1828
KB977444
January 2010
10.00.1823
KB975976
November 2009
10.00.1818
KB973601
September 2009
10.00.1812
KB971490
July 2009
10.00.1806
KB969531
May 2009
10.00.1798
KB963036
March 2009
10.00.1787
KB960484
January 2009
10.00.1779
KB958186
November 2008
10.00.1763
KB956717
November 2008
RTM
10.00.1600
 
August 2008


SQL Server 2005
Version
Build
KB
Release Date
9.00.5266
KB2507769
March 2011
9.00.5259
KB2489409
February 2011
9.00.5254
KB2464079
December 2010
9.00.5000
KB2463332
December 2010
9.00.4325
KB2507766
March 2011
9.00.4317
KB2489375
February 2011
9.00.4315
KB2438344
December 2010
9.00.4311
KB2345449
October 2010
9.00.4309
KB2258854
August 2010
9.00.4305
KB983329
June 2010
9.00.4294
KB980176
April 2010
9.00.4285
KB978915
February 2010
9.00.4273
KB960598
December 2009
9.00.4266
KB974648
October 2009
9.00.4230
KB972511
August 2009
9.00.4226
KB970279
June 2009
9.00.4220
KB967909
April 2009
9.00.4211
KB961930
February 2009
9.00.4207
KB959195
December 2008
9.00.4035
KB955706
December 2008
9.00.3356
KB976952
December 2009
9.00.3355
KB974647
October 2009
9.00.3330
KB972510
August 2009
9.00.3328
KB970278
June 2009
9.00.3325
KB967908
March 2009
9.00.3315
KB962970
February 2009
9.00.3301
KB958735
December 2008
9.00.3294
KB956854
October 2008
9.00.3282
KB953752
August 2008
9.00.3257
KB951217
June 2008
9.00.3239
KB949095
April 2008
9.00.3228
KB946608
February 2008
9.00.3215
KB943656
December 2007
9.00.3200
KB941450
October 2007
9.00.3186
KB939537
August 2007
9.00.3175
KB936305
June 2007
9.00.3161
KB935356
April 2007
9.00.3042
KB921896
February 2007
9.00.2153
KB918222
September 2006
9.00.2047
KB913090
April 2006
RTM
9.00.1399
 
November 2005


SQL Server 2000
Version
Build
KB
Release Date
8.00.2187
KB916287
October 2006
8.00.2039
 
May 2005
8.00.760
 
August 2003
8.00.532
 
February 2003
8.00.384
 
June 2001
RTM 8.00.194   November 2000

Ben Kimim ?

Celiker BahceciMerhabalar, ben Çeliker BAHÇECİ. 2004 den beri özel sektörde bilgisayar mühendisligi ve egitmenlik yapıyorum. Yine aynı yılın Ekim ayından beri sitemde .Net ile programlama ve hayat görüşüm ile ilgili makalelerimi yayınlıyorum. Blogum dışında Yazgelistir.com, mobilnedir.com gibi ineta kapsamındaki bir çok siteye Microsoft teknolojileri ile ilgili yazılar yazmaktayım.
Bu site ile sizinde hayatınızı anlamlandırmanızda bir parça katkımın olması dilegiyle...